Conditionally formatting a cell based on other cell values

I

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!
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditionally formatting 3
Conditional Formatting 1
Conditiona format based on format of another cell 1
Using the Icon Set for Conditional Formatting 1
[XL07] Conditionally format fill color for entire row 10
Conditional format a column based on value in a different column 3
Conditional Formatting Driving Me Crazy 1
Formatting a cell with colour based on whether another cell's valu 1

Top