Conditional formatting
 

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



--
Clare

Conditional formatting
 

Conditional FormattingCell Value is: equal to Yes

Format to red font.


Gord Dibben MS Excel MVP

On Sun, 5 Jul 2009 11:46:01 -0700, Clare
wrote:

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

Conditional formatting
 

Thanks ill this work in excel 2003 too
--
Clare


"Clare" wrote:

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



--
Clare

Conditional formatting
 

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


"Clare" wrote:

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



--
Clare

Conditional formatting
 

Yes.

Did you try it?


Gord

On Sun, 5 Jul 2009 12:22:01 -0700, Clare
wrote:

Thanks ill this work in excel 2003 too

Conditional formatting
 

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
--
Clare


"Gord Dibben" wrote:

Yes.

Did you try it?


Gord

On Sun, 5 Jul 2009 12:22:01 -0700, Clare
wrote:

Thanks ill this work in excel 2003 too