I have a ss in which I am trying to apply conditional formatting to a particular cell with 3 criteria. The problem is that even blank cells are being formatted.
Here are the criteria I am looking to format:
If M6 is between -50 and 100 cell needs to be yellow
If M6 is between -51 and -100 cell needs to be silver
if M6 is between -101 and -150 cell needs to be red.
I believe I need to base it on a formula but can't seem to get it to work. Any help would be appreciated.
hi there scsuflyboy. it's good to put in the version of Excel you are using so that we can provide you newer & better additions. Conditional formatting is different between 2003 & 2007. select the range you want to apply to (say M6:M100)
in Excel 2007 & above, go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
in Excel 2003, go to Format -> Conditional Formatting -> Formula is:
=AND(M6>=-50,M6<=100,M6<>"")
format as yellow
do the same for the rest, changing the 1st & 2nd value. you probably missed out the 3rd for blanks to get formatted. blanks is equivalent to 0.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks