| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
