This may have been answered on here but can not seem to find it. My situation is I have values in A1,A2 & A3 that are like counter reading so the value is always changing. What I am looking to do is change the cell color if one of the values is over 500 from the other two values. Say A1 is 3000, A2 is 3250 and A3 is 3500. I would like the cell for A3 to change color.
Last edited by tvonbehren; 09-16-2009 at 12:33 PM.
Select A1 and go to Home tab and select Conditional Formatting, New Rule
Select Use formula to determine which cell to format and enter formula
=OR(A1-A2>500,A1-A3>500)
click Format and choose colour.
Click Ok to exit
Select A2 and repeat with following
=OR(A2-A1>500,A2-A3>500)
the repeat for A3, with following
=OR(A3-A1>500,A3-A2>500)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thank you Very much is exaclty what I was looking for. Works great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks