REMINDERS BASED ON THE DATE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ILYAS - 08 Jan 2006 11:56 GMT

I USE EXCEL WORKSHEET TO MAINTAIN EMPLOYEES VISA EXPIRY, LICENSE EXPIRY ETC.
WILL ANYONE TELL ME HOW TO MAKE A FORMULAE TO USE THE EXPIRY DATE COLUMN TO
REMIND ME AND SEND SOME KIND OF REMINDERS ?

Reply to this Message

R.VENKATARAMAN - 08 Jan 2006 14:28 GMT

try conditional format (if cell value >=today() make it (for example ) the
cell red
copy this conitional format(by using format brush) to all the cells down the
column

> I USE EXCEL WORKSHEET TO MAINTAIN EMPLOYEES VISA EXPIRY, LICENSE EXPIRY ETC.
> WILL ANYONE TELL ME HOW TO MAKE A FORMULAE TO USE THE EXPIRY DATE COLUMN TO
> REMIND ME AND SEND SOME KIND OF REMINDERS ?

Reply to this Message

George Gee - 08 Jan 2006 15:59 GMT

Ilyas

Assuming you wish to remind employees 7 days before expiry,
and that the expiry date is in E3.

In E3 > Format > Conditional Formatting >
Condition 1, Formula is: =IF(E3>TODAY(),TRUE) (Format black font)
Condition 2, Formula is: =IF(E3>TODAY()-7,TRUE) (Format red font)
Copy down using the Format painter, as far as needed.

The above example will give you a 7 day 'window', in which the date
will be red colour. If you wish to have more of a window, adjust the
value in Condition 2.

Please turn off your CAPS lock!

George Gee

> I USE EXCEL WORKSHEET TO MAINTAIN EMPLOYEES VISA EXPIRY, LICENSE
> EXPIRY ETC. WILL ANYONE TELL ME HOW TO MAKE A FORMULAE TO USE THE
> EXPIRY DATE COLUMN TO REMIND ME AND SEND SOME KIND OF REMINDERS ?

Reply to this Message