|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 5th, 2009, 07:46 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
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 
|
|
#2
July 5th, 2009, 08:02 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#3
July 5th, 2009, 08:22 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#4
July 5th, 2009, 08:23 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#5
July 5th, 2009, 08:45 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#6
July 5th, 2009, 08:59 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
