Color row cells if conditions met

[artz]

Hi,

I have a worksheet that I want to apply conditional formatting to. The condition is that if there is a "Yes" in a cell in column G, that particular row from column A to G would be highlighted in light green.

Is there a way to do this without using VBA? If not, could someone in the Forum suggest some code to do this?

Thanks,

Art

 

[mart37]

Select A2:G till last row. (Not whole columns because CF is very heavy for your system.)
Make in CF a new rule with: $G2="Yes"

 

[artz]

Hi mart37,

I selected cells A2:G45. From the CF menus I picked: New Rule. From that dropdown I selected "Use a formula to determine which cells to format." Next I added your formula $G2="Yes". I used the format button to select a color. Then clicked OK.

This did not apply color to the row where "Yes" was present in cells in column G.

Did I do this correctly?

Thanks,

Art

 

[Rick Rothstein]

I selected cells A2:G45. From the CF menus I picked: New Rule. From that dropdown I selected "Use a formula to determine which cells to format." Next I added your formula $G2="Yes". I used the format button to select a color. Then clicked OK.

This did not apply color to the row where "Yes" was present in cells in column G.

Did I do this correctly?

You need to use this formula (note the leading equal sign)...

=$G2="Yes"

 

[artz]

Hi Rick,

Thanks for reply and suggestion. The leading equal sign did the trick.

Art