help with a conditional formatting formula

[todd]

Hi, I am trying to make a formula using conditional
formating to turn a cell (A9)red if two cells match and a
third doesn't.

Here is what I have and it isn't working. Can someone
help?

=If(AND(B4=B10,(A10<>B10)))


B4 = Invoices to Enter
B10 = Invoices Entered
A10 = Information Entered Verified

A9 = cell with conditional format

 

[Frank Kabel]

Hi
try
=AND(B4=B10,A10<>B10)

 

[Bob Phillips]

Todd,

Just use

=AND(B4=B10,A10<>B10)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)