Conditional Formatting with Dates

M

Mike

I have a report with a column of dates. I want to format
the dates so that they change colors when they are getting
close to, or are beyond the system date. (5 days to the
system date = blue, on the system date = yellow, past the
system date = red) I tried going into the conditional
formatting and choosing <, =, >, sysdate, but that didn't
work.

Thank you very much for your input.
 
S

Steve Schapel

Mike,

The system date is returned by the Date() function. You should be able
to use this in the Field Value Is
(blue) between Date()-5 and Date()
(yellow) equal to Date()
(red) greater than Date()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel due and overdue date colours 2
Conditional formatting dates 3
Conditional Formatting 2
Excel conditional formatting with Weeknum 4
Excel Colour code dates 1
Conditional formatting of date supplied by a form 1
Conditional Formatting Question MS Access 20002 7
Conditional Formatting 3

Top