LinkBack URL
About LinkBacks
Hello everyone,
I would like to mark in red column B whenever the time is after column A (here 11:36 after 10:00), without having to split the cell B in two (date and time)
New display.emf.jpg
Create conditional formatting using time / date-time
Hello everyone,
I would like to mark in red column B whenever the time is after column A (here 11:36 after 10:00), without having to split the cell B in two (date and time)
New display.emf.jpg
Last edited by Halidat; 10-13-2021 at 10:00 AM.
try
=A2 < TIME(HOUR(B2),MINUTE(B2),SECOND(B2))
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.
Works well! Thank you very much!
you are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks