How to conditionally format a cell based on time?

microsoft-excel conditional-formatting

You can use something like this:

=HOUR(A1)=HOUR(NOW())

Where A1 is the first cell that contains a time. Note the applies to range.

enter image description here

Related

Unable to view browser login screen at hotels and libraries
How to get nested if statement to work when checking for an initial value
Disk is apparently in use by the system
How to get the raw number of bytes that a given PID is using from the Linux terminal regardless of distro?
How can I write a formula to conditional format cells that contain two ampersands anywhere within the cell?
Compute checksums for a random selection of files whose names are listed in a file
Does Windows' tasklist tool consider a "K" to be 1000 or 1024 bytes?
Is there a way to configure VLC to remember which video I was on when I open a folder?
Where is the extension menu in gimp 2.6 for windows?
How to add a prefix to a cell that the user can't delete but they can add data behind the prefix
Server File System Structure
Meaning of "the lock of someone's personality" [closed]