Help needed with date function

  • Thread starter Thread starter Cyber Guy
  • Start date Start date
C

Cyber Guy

Hi all

I am making a 3 page spread sheet which will have a column with
different dates. The idea is that something needs to be done at that
particular date and I need to program excel to warn me when the date is
approaching. It is almost like I need it to be an electronic calendar
with alarm.

Very simply: one sheet has the dates in a column. Each cell has a
different date (not necessarily in cronological order). I am using the
dd/mm/yy format (Europe) and I want to have another sheet which,
amongst other data, will have a space / cell reserved for this warning.

I hope I have been clear enough. It's quite difficult to explain.

Thanks
 
Cyber

Check out the function of Conditional Formatting under Format>CF.

First link the cell on Sheet2 back to Sheet1 using Copy>Paste Special>Paste
Links.

Then on Sheet2 Format>CF>Formula is: =cellref<TODAY()+6

Pick a nice bright color from Format>Patterns.

This cell will turn that color when the date is 5 days or less from Today.


Gord Dibben Excel MVP
 
Back
Top