Conditional Formatting with Dates

  • Thread starter Thread starter Mike
  • Start date Start date
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.
 
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()
 
You must log in or register to reply here.

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 Macro to automatically go to the right of the last colored cell 0
Conditional formatting of date supplied by a form 1
Excel Colour code dates 1
Conditional Formatting 3

Back
Top