Conditionally formatting a cell based on other cell values

[ian]

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!

 

[Fred Smith]

You can do this with conditional formatting. Say A1 is the cell you want
formatted, and B1 is your other cell. Then use:
=a1>b1
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

 

[T. Valko]

What version of Excel are you using?