I have a column with values, some zero and some greater than zero. These
values are the result of a formula. Whenever the value is higer than 0, the
conditional format wil highlight that value bold & blue.

Now, i've changed the formula with a VLOOKUP. It looks for a value in
another worksheet, if it doesn't find it there, it will use another formula
and use that value.

=IF(P50,VLOOKUP(A5,Variance!C:M,10,FALSE),IF(L5<M 5,L5,M5))

Now, if the VLOOKUP in this formula returns anything at all, than I want the
cell to be highlighted. I don't know if I can use conditional format for
this. The VLOOKUP might return value 8 for example. but the sencond IF
statement can display 8 as well. If the 8 is a result of the VLOOKUP, i want
the font to change to red. If the second IF statement results in a value
greater than 0, I want the font to change to bold & blue.

Thanks for helping in this seemingly impossible to resolve issue.