Conditional Format on another cell's value
 

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.

Conditional Format on another cell's value
 

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.

Conditional Format on another cell's value
 

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" wrote:

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.

Conditional Format on another cell's value
 

Try this:

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

--
Biff
Microsoft Excel MVP


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

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.

Conditional Format on another cell's value
 

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" wrote:

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" wrote:

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.

Conditional Format on another cell's value
 

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

Ricky

"RicardoE" wrote:


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" wrote:

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" wrote:

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.

Conditional Format on another cell's value
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"RicardoE" wrote in message
...
That's beautiful, love the logic function! I'll use the AND function.
Thanks a bunch, nicely done! :-)

Ricky

"RicardoE" wrote:


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" wrote:

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" wrote:

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.

Conditional Format on another cell's value
 

yes

"RicardoE" wrote:

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.