Conditional Format on another cell's value

[RicardoE]

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.

 

[T. Valko]

Try this:

Formula Is: =B1<>$A1

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

 

[RicardoE]

Thanks! That works pretty well! Except, as you indicated, empty cells will
also be highlighted RED. What can I do in that case? I want empty cells to
be ignored.

 

[T. Valko]

Try this:

=AND($A1<>"",B1<>"",B1<>$A1)

 

[RicardoE]

Cool I figured it out, it's pretty easy. I have two conditions for my
formulae:

Condition #1:
=COUNTBLANK(L2)=1
then color the FONT in this cell BLUE... of course this won't do anything
since the cell is empty anyway!

Condition #2:
=$B2<>$L2
then color the cell RED, which is what I want

And if they are equal, then the cell remains as is (no color).

Thanks for your help!

Ricky.

 

[RicardoE]

That's beautiful, love the logic function! I'll use the AND function.
Thanks a bunch, nicely done!

Ricky

 

[T. Valko]

You're welcome. Thanks for the feedback!

 

[laquesha]

yes