No need for IF

=AND(D7="Yes",D8=0)

change the condition to formula is.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

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