Archive of Mr Excel Message BoardArchive of Mr Excel Message Board
I am looking for a "conditional format" for each of the 3 columns to code the cells with a certain time range a different color dependant on the elapsed time.
I have tried and tried to conditionally format the columns but I get no result from the normal conditional format. Any suggestions are appreciated.
Lets say you want to highlight everything over 90 days.
Under conditional formatting, select cell value and type in 90 and then your format.
Anything over 90 days 12 hours would be over 90.5 etc. Remember, formats don't have any affect, excel is still "storing" time as 1 = 1 day.
Hope that answers your question.
Good luck
That does help, however, what I am working on is VERY time sensitive and needs to be tracked in 4 hr increments, so with the supplied formula and custom format, I can not find a working conditional format. If I understand your statements above, I could conditional format based on 1/4's of the day????
Lets say you want three condintional formats, over 4 hours, over 8 and over 12
Do your longest time as the first conditions, down the shortest as number 3
anything over 12 hours is > .5 (12 hours/24)
anything over 8 hours is >.333333 (8/24)
anything over 4 hours is > .166667 (4/24)
Is that what you mean? I'm a little confused because you refer to both four hour periods and quarters of a day.
That got it, works like a champ, Thanks for the assist, you guys are great!!!