Conditionally formatting a cell based on other cell values

  • Thread starter Thread starter ian
  • Start date Start date
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!
 
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

Conditional format a column based on value in a different column 3
Conditional Formatting Driving Me Crazy 1
Conditional Formatting 1
Conditional Format Won't Update Cell 8
Multiple Variables in Conditional Formatting with Excel 2003 1
Formatting a cell with colour based on whether another cell's valu 1
Excel Conditioning Formatting 3
Using the Icon Set for Conditional Formatting 1

Back
Top