Conditional Formatting Help

[SantasLittleHelper]

I would like to highlight dates that are older than 3 months and 6 months.

E.g. 'Start Date' needs to be highlighted yellow if it is older than 3 months from todays date and highlighted red if it is older than 6 months from todays date.

 

[Special-K99]

Select a date, e.g. A1

Conditional Formatting
New Rule
Use a formula to determine...
2 rules required in this order

=AND(A1<EDATE(TODAY,-3),A1<>0)
format as yellow

=AND(A1<EDATE(TODAY,-6),A1<>0)
format as red

Use Format painter (paintbrush icon) to copy to other cells

 

[SantasLittleHelper]

Is this for Access?

 

[Special-K99]

Sorry I didn't spot that. No, Excel

 

[Joe4]

Are you trying to do this on a Form or a Report?

 

[SantasLittleHelper]

On a Report

 

[Joe4]

In Design View, right-click on the field, select Conditional Formatting, and enter the following:
Field Value Is -> Less Than -> Dateadd("m",-6,Date())
and select the Red highlighting option

Then, right-click on the field and select Conditional Formatting again, then click the Add button to add another conditions and enter:
Field Value Is -> Less Than -> Dateadd("m",-3,Date())
and select the Yellow highlighting option