cell-based conditional formatting on the whole row (Excel 2007)

[abc]

Hi All,


I have setup a conditional formatting rule that shows cells in column B
in red if the cell contains a "Y" and in green if it contains a "N".

How can I make so that the whole row receives the same color of the cell?

Example: cell B5 contains a "Y" character, so it is colored in red. How
can I make the whole row 5 become red as cell B5 contains a "Y"?

Thanks in advance!

 

[Per Jessen]

Hi

Select the entire row and got Contitional Formatting > Condition 1:
Formula Is > Enter this formula : =$B5="Y" > Format as desired.

Hopes this helps