Conditional formatting: TIME greater then...
Hello everyone!
I am fighting with conditional formatting for times in excel.
All the time cells are in the format: mm:ss;@. The value is retrieved trough a VLOOKUP from another sheet, same format, mm:ss;@
The idea is:
<= 8:30 (mm:ss) Green.
> 8:30 <= 9:00 Yellow
>9:00 Red.
Does anyone have an idea how I can achieve the wanted?
Any help is greatly appreciated.
Chris!
Can you post a sample of your workbook for the members to work with..
To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
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
Hi Chris!
You can create three conditional formatting for your case.
I make a little sheet to show.
CHRIS_EX.xlsx
hi Chris, welcome to the forum. select from whatever range you need (say from A2:A10), then press ALT + O + D & use this formula:
=A2<=TIME(8,30,0)
format as green
do the same for the 2nd & use this formula instead:
=AND(A2>TIME(8,30,0),A2<=TIME(9,0,0))
format as yellow
if you have dates inside the time, it you have to add MOD to A2. for eg.
=MOD(A2,1)<=TIME(8,30,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
Thank you all!
For some reason it is working fine with the solution that lmonteiro provided. I think I was over complicating things.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks