Conditional format based on current time in a cell

[sknight0980]

Hello,

Ive been searching to try and find the answer to my question below but unable to find anything that can help.

I have a spreadsheet with rows containing deliveries with a date and timestamp in the format 06/01/2022 05:58 on each row in column P. At the top of my sheet I have

=NOW()

to show the current time.

What I would like to do is apply a conditional format to highlight each row which contains a date/time which is within 2 hours of the current time (at the top of the sheet) but struggling to make it work.

Any help is much appreciated.

 

[Saurabhj]

Hi,

Use below formula in Conditional Formatting. (See Image)

=$P$1-P2<=2/24

 

[MissGriffieth]

Thank you so much for this answer, Saurabhj--I do so appreciate it! It is related to my question (posted 1/6/2022 at 5:21 p.m.), and although I cannot get it to answer my question for the specific concerns I had, I have used what you wrote here, made some modifications, and was able to make a work-around that will work. Thank you! I have been working on this for over five hours now, and so appreciate the direction here! Thanks again!