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!