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()
 
Back
Top