shade a row based on the current time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Use conditional formatting.

In the cell that has the time (assumed to be A1 here), choose Format>Conditional
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I highlight a row in Excel based on the current time? 2
alternate row shading on filtered data 2
Unwanted shading of entire spreadsheet 2
Calculating Shaded Cells 2
Conditional Format based on dates 3
Identify the Current Cell 5
Automatically Copy formatting (I.E. shading) 2
How to filter rows data based on background color of individual cells 1

Back
Top