Conditional formatting

[Clare]

Formula:- =IF(T3<=R3,"No","Yes")

Could some please tell me how to make the yes turn red in the cell. I am
using excel 2003

Thanks

 

[Eduardo]

Hi,
Highlight the column where the yes and no are, then conditional formating,
text that contains enter "YES"

 

[Jacob Skaria]

Hi Clare

Select the cells to be formatted; Choose Format>Conditional
Formatting..Select 'Cell Value Is' and enter 'Yes' and select a color

Refer the below link for detailed help

http://www.contextures.com/xlCondFormat01.html

If this post helps click Yes