Format on date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a date field that is part of an aging report which i would like the
text to turn red if the date is 90 days from current date.Is this done
through conditional format and how would it be done.
 
Yes. Assuming that's 90 days or more *before* current date. In the
conditional formatting dialogue:

Field Value Is less than or equal to Date()-90

and set it to red with the Font/fore color button in the dialogue.

It can also be done in code in the section's Format event procedure by
changing the ForeColor property of the control conditionally to red or black.

Ken Sheridan
Stafford, England
 

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

PLEASE HELP ME 1
Excel Excel due and overdue date colours 2
IIf statement with a Nz 5
Date Brackets as an IIf statement 3
Using Crosstab column headings for conditional formatting in report 0
making age group query work 7
Excel Colour code dates 1
Excel Vba to change displayed year automatically. 14

Back
Top