I am working on a database where I would like certain cells (K7) to highlight based on data in another cell (I7). I only want cell K7 to highlight if the number is cell I7 is between 1-50 and if I7 is blank for nothing to happen. Can someone help?
I am working on a database where I would like certain cells (K7) to highlight based on data in another cell (I7). I only want cell K7 to highlight if the number is cell I7 is between 1-50 and if I7 is blank for nothing to happen. Can someone help?
hi Kristenmrn, welcome to the forum. select K7 & go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=AND($I$7>=1,$I$7<=50)
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
Thank you! It worked!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks