| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting on empty cells
I'm setting up a new report for the month of July and creating formatting
rules for data that will be entered throughout the month. However, when I apply my rules to cells that have not yet got data entered (eg. for next week) it is showing up as "formatted" even though the cell is empty. Is there an override for this conditional formatting so that it the formatting won't show up until I enter something in that cell? I'm new to Excel 2007. Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| How can I deactivate conditional formatting if the cell is empty? | Excel Discussion (Misc queries) | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
| Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions | |||
Threaded Mode
