Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check dates in spreadsheet against expiry years column and change colour
Hi All
I need some help I have a training spreadsheet that has a list of trainees names across the top and down the side the course name and the validity period. Within the spreadsheet I have the dates that the person recieved their training. What I am wondering is can I get a function to look up the validity period eg 2 yrs and check it against the date and change the colour to red when it has expired, orange when 2 months away from expiry and green when current? Please help Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check dates in spreadsheet against expiry years column and change
Perfectly feasible, you can do this with conditional formatting but it
probably helps if there is a consistency in the validity period, e.g. if you have "2 yrs", "6 months" etc. this will be trickier to implement. Just a figure in the validity column, indicating months, or years, in all cases would make things easier. What do you have currently in validity column? " wrote: Hi All I need some help I have a training spreadsheet that has a list of trainees names across the top and down the side the course name and the validity period. Within the spreadsheet I have the dates that the person recieved their training. What I am wondering is can I get a function to look up the validity period eg 2 yrs and check it against the date and change the colour to red when it has expired, orange when 2 months away from expiry and green when current? Please help Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check dates in spreadsheet against expiry years column and change
In the validity column I have years ranging from 1-5 yrs at this stage
none of them are in months. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check dates in spreadsheet against expiry years column and change
Thanks for your help have just had a play with it and figured out how
to do it myself. Seems I am smarter than I thought ;) wrote: In the validity column I have years ranging from 1-5 yrs at this stage none of them are in months. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check dates in spreadsheet against expiry years column and change
" wrote: Hi All I need some help I have a training spreadsheet that has a list of trainees names across the top and down the side the course name and the validity period. Within the spreadsheet I have the dates that the person recieved their training. What I am wondering is can I get a function to look up the validity period eg 2 yrs and check it against the date and change the colour to red when it has expired, orange when 2 months away from expiry and green when current? Please help Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
Date formulas | Excel Discussion (Misc queries) | |||
macro | Excel Discussion (Misc queries) | |||
how to change format of several dates entered in an Excel column | New Users to Excel | |||
Can I change a column of dates from USA to UK format? | Excel Discussion (Misc queries) |