Upcoming Date alerts

[Guest]

Is there a way I can have an Excel 2003 worksheet notify me of upcoming
dates? Ex: I have a spreadsheet tracking safety course expirey dates, and
would like to have the cells highlight prior to that date, say 1 month in
advance. Will conditional formatting do this, and if so, how?

 

[Guest]

TRY:

Assuming dates are in column A, highlight column A, then in Conditional
Formatting set "Formula is" to =(A1<=TODAY()+30)

and set to required colour.

HTH

 

[Guest]

Are start and end cell #'s required?

TRY:

Assuming dates are in column A, highlight column A, then in Conditional
Formatting set "Formula is" to =(A1<=TODAY()+30)

and set to required colour.

HTH

 

[Guest]

For some reason, it highlights all sorts of cells, but not the ones I need.
Any suggestions?

 

[Guest]

The current test should highlight any expiry date within 30 days of today i.e
any dates before 30th June 2006. Is this what is required or have I
misunderstood?

 

[Guest]

Your understanding is correct. My spreadsheet, however,isn't doing it. In my
case, the datres I'm tracking are in column G, starting @ G6 through G77.
I've tried highlightong the entire G column and inputting your formula, as
well as just highlighting G6-G77. Each time, it highlights all sorts of
cells, some with dates
such as 10-Oct-08, but ironically not 23-Jun-06. I've also tried changing
the cell date format to an all numeric version, with no change.

 

[Guest]

Check that (some of) the fields are not formatted as text rather than dates.
I have re-checked my formatting and it works with date fields but fails if
they are text fields.

 

[Guest]

Perfect! Thank you! One last question, some of the cells are blank (IE no
course required for that person) is there an additional format to not
highlight those?

 

[Guest]

=and(a1<=today()+30,a1<>"")

Perfect! Thank you! One last question, some of the cells are blank (IE no
course required for that person) is there an additional format to not
highlight those?

 

[Guest]

Thank you for your assistance.

=and(a1<=today()+30,a1<>"")