| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formmating
Using Excel 2003
I have a range of cells from A1 to A20 that has conditional formmating. If someone enters a number from zero to 4.5, the background turns green. The problem is, before someone even enters a number, the background is green. Why is this? I don't want to confuse the data entry person. I have 2 other conditions in those cells that turn the cells yellow and red when other values are entered. How can I get rid of the green background? Thank you, Karen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
| Conditional Rank (or rather, Conditional Range) | Excel Worksheet Functions | |||
| Conditional Sum | Excel Worksheet Functions | |||
| conditional formmating data and put it into a graph... | Charts and Charting in Excel | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Threaded Mode
