Hello,

I would like to set up CF to highlight the current cell RED if its contents
do not equal the contents of another cell. For instance, if cell A1 has the
contents "apple" and cell B1 has the contents "appel" then I want cell B1 to
be highlighted RED. Of course, if cell B1 has the content "apple" then I
want nothing to happen. I have tried to put the following formula as the CF
Formula for cell B1 -- "Formula Is: =$A$1=1" but nothing happened
regardless of the contents of B1 (apple or appel). Thanks for your help,

Ricky.