| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional format
I'm having an issue getting my condtional format to read negative numbers.
The format is if the reference cell is less then 100 fill the box red. The reference cell is a lookup value. The conditional format works for everything including zero but once you hit -1 it goes back to green (a different conditional format for 100) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to copy a conditional format formula as paste value | Excel Discussion (Misc queries) | |||
| Conditional Format | Excel Discussion (Misc queries) | |||
| Conditional Formating. Remove condition, keep format? | Excel Discussion (Misc queries) | |||
| How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
| Cell Format Changes When Data Is Entered - Not Conditional Formatt | Excel Worksheet Functions | |||
Threaded Mode
