I think you need something like
=IF(AND(B5="M",B8LOOKUP(B7,Data!F3:F38,Data!E3:E3 8)),TRUE(),FALSE())


"Sean Timmons" wrote:

In Conditional formatting, change to formula is from the drop-down

=IF(AND(B5="M",B8LOOKUP(B7,Data!F3:F38,Data!E3:E3 8)))

Then format as needed.

"Ben A" wrote:

=IF(B5="M",IF(B8LOOKUP(B7,Data!F3:F38,Data!E3:E38 ),"Fail"
If I enter the above formula into a cell it works great and will display the
word fail within the cell. I don't want to do that though I just want the
"B8" cell to change color if the statement is true. How do I do this?
--
Ben A


"Glenn" wrote:

Ben A wrote:
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".


The formula above would not work outside of conditional formatting. Copy it
directly from a working cell to your post and try again.