| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting using clock time
How can I highlight the entire row based on the value of column "E" when
column "E" is a TIME based on the 24hr clock. I need rows with a the time in column "E" between 3:00 pm (15:00) and 5:59 am (05:59) (evening/night shift) to be shaded. But I do not want times between 6:00 am (06:00) and 2:59 pm (14:59) (day shift) to be shaded. Any help will be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting with Date and time | Excel Discussion (Misc queries) | |||
| conditional formatting with time values | Excel Discussion (Misc queries) | |||
| can cell's act like time clock at a certen time/date for payments | Excel Discussion (Misc queries) | |||
| conditional formatting 24-hour clock | Excel Worksheet Functions | |||
| Time Clock | Excel Worksheet Functions | |||
Threaded Mode
