I have a tracker with 3 primary columns. Column A has the current date, Column B has a Starting Time, Column C has an Ending Time.
If Column C has a time entered in it which is past the current time, I need Column A to change color.
I've tried a few different NOW formulas, but I'm having a hard time!
Selecting your range in A (lets say A2:A1000)
=AND(ISNUMBER(C2), C2> MOD(NOW(),1))
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
No it didn't
Here is an example, any hour in C that is after current time should turn red.
To attach an example, Go Advanced>Manage Attachments
Could you have a cell with the =now() formula anywhere avalable, then reference that within a conditional formatting set-up? This would make your formula easier maybe. It could just check wherever you have =now() against each cell for >greater than and highlight.
Thank you so much, ChemistB!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks