Thread: Conditional Format a cell that contains a function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Matheus Matheus is offline
external usenet poster
  
Posts: 16
Default 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?
Reply With QuoteReply With Quote