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!

Hi

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

Hopes this helps

----
Per


On 4 Apr., 00:21, abc <nos...@nospam.nospam> wrote:
> 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!