| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format a cell that contains a function
conditions 1 and 2 don't work becase the cells are
not blank - they contain the VLOOKUP. Do the lookup formulas return blank cells? Try this: Condition 1 RED: =AND(COUNT(C5:C6)=2,C5C6) Condition 2 GREEN: =AND(COUNT(C5:C6)=2,C5<=C6) Condiion 3 GRAY: =AND(COUNT(C5),C6="") -- Biff Microsoft Excel MVP "Matheus" wrote in message ... 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? |
| Reply |
| 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) | |||
Linear Mode
