M
Matheus
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?
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?