Conditional formatting

[Clare]

Hi

I've got the undernoted formula on my spreadsheet:-

=IF(T3<=R3,"No","Yes")

Could someone tell me how to make the yes turn red in the cell

Thanks

 

[Gord Dibben]

Conditional Formatting>Cell Value is: equal to Yes

Format to red font.


Gord Dibben MS Excel MVP

 

[Clare]

Thanks ill this work in excel 2003 too

 

[Clare]

Thanks very much but will this work in excel 2003 as well

 

[Gord Dibben]

Yes.

Did you try it?


Gord

 

[Clare]

I'm working from home right now and it worked on 2007 but will be using the
spreadsheet on 2003 when at work not back til tomorrow so will try then

Thanks again for your help