| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
shade a row based on the current time
I have a spreadsheet that is utilized as a schedule for phone coverage. Each
cell is in half hour increments. I want to have the current time in one cell that the rest of the cells reference in a formula to highlight the row that fits the timeframe. How can I do this? Or is it even possible? Or is there another appllication that might be better? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
shade a row based on the current time
Use conditional formatting.
In the cell that has the time (assumed to be A1 here), choose FormatConditional Formatting... Change Condition 1 to Formula is, enter the following formula =AND(INT(A1/"00:30")*"00:30"<NOW()-TODAY(),INT(A1/"00:30")*"00:30"+"00:30"NOW()-TODAY()) Choose Format..., and whatever highlight you want, such as Pattern grey. Copy the formatting as far down as needed. -- Regards, Fred "Lorri" wrote in message ... I have a spreadsheet that is utilized as a schedule for phone coverage. Each cell is in half hour increments. I want to have the current time in one cell that the rest of the cells reference in a formula to highlight the row that fits the timeframe. How can I do this? Or is it even possible? Or is there another appllication that might be better? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
| Find a time value in one column based on names in another | Excel Discussion (Misc queries) | |||
| Run macro based on time | Excel Worksheet Functions | |||
| How to enter current static time in Excel in 00:00:00.0 format? | Excel Worksheet Functions | |||
| how do i insert the current time into a cell, and show different . | Excel Discussion (Misc queries) | |||
Linear Mode
