Good question.
I don't think you can.
I think the IF has to refer to the cell itself.


"John" a écrit dans le message de news:
...
I am trying to put an IF & AND function into Conditional Formating but I am
not getting the required result.

I am trying to express "If D7 = Yes AND D8=0 THEN Change Font in D8 to
Red"

How would I express this in Conditional Formatting?


Thanks