Conditional format a cell based on text in adjacent column

[laura_pink]

Hi,
This seems pretty simple but I can't get it working.
Lets say column A is a Yes or No column. I want column B to shade in red if a "Y" or "YES" has been entered into column A.
Thanks!

 

[Joe4]

Highlight column B, then go to Conditional Formatting, choose the Formula option, and enter this Conditional Formatting formula:

=OR(Upper(A1)="Y",Upper(A1)="YES")

and choose your red shading.

 

[laura_pink]

BRILLIANT! Worked first time. Thanks so much.

 

[Joe4]

You are welcome!
Glad to help!