help with a conditional formatting formula

  • Thread starter Thread starter todd
  • Start date Start date
T

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
 
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)
 
Back
Top