I have a vlookup formula in cell G39, which looks up a value on another worksheet, =IF(ISNA(VLOOKUP($G$29,B620_CPS,6,)),"",VLOOKUP($G$29,B620_CPS,6,)). Then in cell G27 I have a word which I want to turn red if this condition is met, =G39>"1999". But it does not work. Any ideas how to make this work.