| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Conditional formating
I have a spreadsheet with multipe dates I want to have dates less than
01/11/2007 in the cell to turn into R with Red background and for dates more than 01/11/2007 to turn into X with Green background and all blank cells to be blank. I can do some of it with 2007excel however I can not get the blank cells to remain blank and how can this be done in excel 2003 |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
Conditional formating
see response to your other posting
-- Regards Roger Govier wrote in message oups.com... I have a spreadsheet with multipe dates I want to have dates less than 01/11/2007 in the cell to turn into R with Red background and for dates more than 01/11/2007 to turn into X with Green background and all blank cells to be blank. I can do some of it with 2007excel however I can not get the blank cells to remain blank and how can this be done in excel 2003 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formating | Excel Discussion (Misc queries) | |||
| Conditional Formating | Charts and Charting in Excel | |||
| conditional formating | Excel Discussion (Misc queries) | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
| Conditional Formating | Excel Worksheet Functions | |||
Linear Mode
