Thank you for the help, but I did not understand the first part of the
equation. I understand how to get the count but, I still cannot figure out
how to have the program automatically highlight the cell when there is a
difference.

"jlclyde" wrote:

On Dec 22, 7:51 am, RoddyRod
wrote:
How can I format spreadsheet cells to change color if values don't match?
For instance, if the text value A455 doesn't equal the text value of B455,
the B455 will automatically highlight to a predetermined color. Also, at
another predetermined cell, I would like the count of the cells which were
unequalled.

Rod,
Go to conditional formatting byFirst selectign the cell that you want
to format/ Format/Conditional Format. Chose Formuls is instead of
Cell is. Then put in =A455<B455. then put in the formats that you
want to include.
Jay