Hi
I am looking to highlight a cell that falls between two hours.
I.E. I have a spreadsheet with hours
14:00 - 15:00
15:00 - 16:00
16:00 - 17:00
I want the spreadsheet to check the current time ( NOW() ? ) and then highlight the cell that falls between that time.
So if it is 16:34 then the cell between 16:00 - 17:00 should be highlighted.
thanks in advance
well with those in a1:a5 use a formula option applied to a1:a5
=AND(MOD(NOW(),1)>=--LEFT(A1,5),MOD(NOW(),1)<--RIGHT(A1,5))
but you are aware that it will not update as now() has to be recalculated and this only happens when you either enter something new in a cell and press enter or press f9
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
you could just use the Hour - if you are happy with 16:00 to 16:59.59
=Hour(Cell) = Hour(Now())
in the conditional format
and so will just check the hour portion
IE in example is HOUR = 16
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thanks Martin, that performs exactly the task I was aiming for.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks