Conditional Formatting with 3 Conditions

[JTL9161]

Trying to write a formula for a 3 condition conditional format.

In cell D10: If cell D10 = F10 then fill cell D10 a color. If D10 <> F10 then no color. If D10 is blank and F10 is blank then no color.

I will use this down the D column but I am only using 1 row for this example.

Appreciate you assistance.
James

 

[Fluff]

You don't need a formula for no colour,so just use
=D10=F10
& select the format you need

 

[JTL9161]

What if its blank? A blank D10 = Blank F10 and I do not want color in D10 then.

 

[jtakw]

Hi,

Try this CF formula:

=AND(D10<>"",D10=F10)