Solved: Conditional Formating or VBA?

[ironj32]

My goal is to have an entire row be filled either Green or Yellow, based upon the value in that last column of the row (column G). If the value of the cell in column g is "Yes", then i would that entire row to be Green. If it is "No", then I would like the row to be Yellow. I can't seem to figure out how to get this to apply to an entire row with the use of Conditional Formating.

If this indeed does require VBA, I would be grateful if you could provide an example for me to follow. Thanks!

[mikerickson]

Select any cell in row 1 and set the condtiional formating to the formula

=($G1="Yes")

Copy this formatting to the rest of the sheet.

[ironj32]

wonderful. thanks!