Changing conditions of cells

[craigwojo]

Hi everyone,

In column "A" is condtional formatted. YES & NO.
In column "B" is a currency value.

When a cell in column A is = "YES" I need the font color in column "B" to be grey.

How can I do this?

Thank you,
Craig

 

[Oaktree]

Select B1:B100 (or whatever your range is) and go to format --> conditional formatting. Change "Cell Value is" to "Formula is" and enter the formula as =A1="YES". Click "Format", and apply the desired formatting if the criterion is met, and click OK twice.