I am trying to create condtional formating to turn a cell red with a complex
IF/ LOOKUP Function for the rule. The Function works outside of conditional
formating but when used with in condtional formating I get no result. What
do I need to do indorder for this work?

The IF/LOOKUP Formula is:
=IF(B5<"M",IF(B8LOOKUP(B7,Data!F3:F38,Data!E3:E38 )" "
The quatation marks have nothing in them because I would like no result just
the number already entered in cell "B8".
--
Ben A