| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format a cell that contains a function
I have the following conditions to format Cell C5:
Condition 1: If C5 is "" -- No Fill on C5 Condition 2: If C6 is "" -- Gray on C5 Condition 3: If C5 <= C6 -- Green on C5 Condition 4: If C5 C6 -- Red on C5 Both C5 and C6 contains VLOOKUP function and both conditions 1 and 2 don't work becase the cells are not blank - they contain the VLOOKUP. Does anybody know a way arround this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format Row when Value Changes in One Cell | Excel Worksheet Functions | |||
| conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
| Conditional Format =max Function | Excel Discussion (Misc queries) | |||
| The conditional format function | Excel Worksheet Functions | |||
| conditional cell format | Excel Discussion (Misc queries) | |||
Threaded Mode
