Conditional Formatting allows up to 3 individual conditions (pre-Excel 2007,
unlimited or at least a lot in Excel 2007), each with its own format (click
the 'add' button). You might consider breaking your formula into two
formulas and putting each in a condition.

--
Jim
"Hendrik" wrote in message
...
|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.