Conditionally formatting a cell based on other cell values
 

I am trying to format a cell based upon the relationship of another cell to a
reference value. For instance if the reference is 5 and the other cell is 4
I want to format the original cell green, if it is the same blue and if it is
less than the reference red.

Can someone help please!

Conditionally formatting a cell based on other cell values
 

Please give a full explanation
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"ian" wrote:

I am trying to format a cell based upon the relationship of another cell to a
reference value. For instance if the reference is 5 and the other cell is 4
I want to format the original cell green, if it is the same blue and if it is
less than the reference red.

Can someone help please!

Conditionally formatting a cell based on other cell values
 

You can do this with conditional formatting. Say A1 is the cell you want
formatted, and B1 is your other cell. Then use:
=a1b1
Select green color
=a1=b1
Select blue color
=a1<b1
Select red color

If you need further help, post back with the version of Excel you are using,
and the specifics on what cells you are using.

Regards,
Fred

"ian" wrote in message
...
I am trying to format a cell based upon the relationship of another cell to
a
reference value. For instance if the reference is 5 and the other cell is
4
I want to format the original cell green, if it is the same blue and if it
is
less than the reference red.

Can someone help please!

Conditionally formatting a cell based on other cell values
 

What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"ian" wrote in message
...
I am trying to format a cell based upon the relationship of another cell to
a
reference value. For instance if the reference is 5 and the other cell is
4
I want to format the original cell green, if it is the same blue and if it
is
less than the reference red.

Can someone help please!