Try this:

Formula Is: =B1<$A1

What about empty cells? Do you need to account for empty cells?

--
Biff
Microsoft Excel MVP


"RicardoE" wrote in message
...
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.