Conditonal Formating [Closed]

Report
-
I have a training spread sheet that is used to track the due date of the training for our field personnel. We also use it to determine if the training will expire prior to a field operation. So when I put in a Field operation date in cell A3 I want to compare it to the training due date in cell H7, if H7 is before A3 I want it to fill orange. I tried cell value < A3 but it gives very strange results. The DateDif function doesn't work when you have a large selection of data. Any ideas.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!