Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
REMINDERS BASED ON THE DATE
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 ? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
REMINDERS BASED ON THE DATE
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 "ILYAS" wrote in message ... 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 ? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
REMINDERS BASED ON THE DATE
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(E3TODAY(),TRUE) (Format black font) Condition 2, Formula is: =IF(E3TODAY()-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 ILYAS wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum based on date in excel | Excel Worksheet Functions | |||
change date based on time | Excel Discussion (Misc queries) | |||
Counting unique records based on date range | Excel Worksheet Functions | |||
sum automatically from last 12 months based on current date | Excel Worksheet Functions | |||
Show a date based on today | Excel Worksheet Functions |