Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COlor Coding specified time frames
I am attemtpting to use validation with date function. Example: I have a
booked date and a specimen date. I want the cell to turn a specific color if the booked date and specimen date is 0-1 days, another color for 2-3 days, etc. Is this possible? I can apply conditional formating to a date just one day greater than my booked date. But that is as far as I can get with the cell coloring. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I subtract time where hh:mm:ss:ff (frames = 30 frames/sec) | Excel Discussion (Misc queries) | |||
Counting time-frames | Excel Discussion (Misc queries) | |||
VBA syntax to check between two time frames i.e. 2 PM thru 5 AM? | Excel Programming | |||
2 Lists but different time frames. | Excel Programming | |||
Calculation of Hrs and Mins from 2 Time Frames | Excel Worksheet Functions |