Highlight time in a weekly booking schedule

[Excel Snejk]

Hi,

I've been trying to make a booking schedule for our group. We book our time slots 30 min at a time and it works fine like this, but I think it would be really cool if the file could highlight (in a certain color) the whole row for the current time. I figured this can be done using conditional formatting, but I don't have the knowledge to write the formula properly. Does anyone of you know how to solve this?

[etaf]

try
=AND(MOD(NOW(),1)>$A4, MOD(NOW(),1)<=$A5)

see column U - just to show the formula in use - not needed , just a visual add

NOT if the spreadsheet is left open , it will NOT change until excel effectively re-calculates F9 is carried out, i think just selecting a different cell may work - i will see in half an hour

Seems to change , i opened up another spreadsheet , and it changed to 12:00 at 12:00 - will see what happens at 12:30

to update live , you will need VBA to do that


for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A4:S28 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=AND(MOD(NOW(),1)>$A4, MOD(NOW(),1)<=$A5)

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

[Marius44]

Hello
Try with VBA code

Please Login or Register  to view this content.

Hello,
Mario

[Excel Snejk]

Hi etaf,

I managed to get your formula to work in Excel 2016 (YAY!), but it didn't translate to the online version of Excel (Teams), as the highlighting never appeared. Is that what you meant by "update live"?

[etaf]

but it didn't translate to the online version of Excel (Teams), as the highlighting never appeared. Is that what you meant by "update live"?

possibly - i have not used the online/teams so not sure

I notice the conditional formatting excel does seem to update automatically now - I would have not expected that without doing something on excel , that used to be the case years ago on older version, maybe things have changed