It's on the Format menu, under Conditional Formatting..

To use it, select cell B1, then go to Format-Conditional Formatting
In the first box select Cell Value is
In the second box select Not Equal to
In the third box type =A1
Click on the format button and choose the attriubtes you want, then OK your
way back to the spreadhseet


"scott45" wrote:

Is it possible to have a cell change color if say the value of cell a1 is
different from b1. I have read about this conditional formating but to be
honest I can not find it under format cells. What am I doing wrong?
Thanks in advance