If this is the wrong place to post this question please let me know.
I would like to make a cell turn red if the value is less than a Value between two separate cells.
Thank you
If this is the wrong place to post this question please let me know.
I would like to make a cell turn red if the value is less than a Value between two separate cells.
Thank you
welcome to the forum. giving cell references & numbers as egs would help a lot (a sample excel file even better). say A1 is 10, B1 is 12. and you would like C1 to be highlighted if A1 is less than B1. try:
select the range you want to apply to (say from C1:C10)
go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=A1<B1
if C1 has another number like 8 & you only want to highlight when both of them is lesser than C1. then:
=AND(C1<A1,C1<B1)
format the colour
Edit: you might want to ask the admins/moderators to help move this thread to General or Formulas/Functions
Last edited by benishiryo; 01-05-2014 at 09:38 PM.
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
Done Ben. Thanks.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks