M
Manxy
Reference old thread: training Out of date formula required:
7/18/2009 5:34 AM PST
Hi Jacob, thank you for showing me the step by step order as this is hugely
appreciated and probably for others who read this.
Being the 19th of June 2009 today and using the cells D3 to D48
I checked the cells using different dates and it came up with this:
2008 dates and upto the 18 Jul 09, there was no colour
19th July 09 only, there was 1 date only and coloured red
20th July 09 to 18th August 09 the colour was orange
19th August 09 to 18th September 09 the colour was yellow
19th September onwards, there was no colour
This is on the right track for what I require using excel
Basically, if I enter an old date say 6th Dec 08, that particular person
would be in date till 5th december 09, but on the 6th December, their
background of the date would turn red to indicate he is now out of date and
remain so until a fresh date has been entered.
Using the above date of 6th December 08, the background colour would be
orange if there was a 1 month gap between 6th November 09 to 5th December 09.
This colour is to indicate that the person needs to be retrained quickly so
that they remain indate
Again using the date entered of 6th December 08, I would like the background
colour to be yellow from 6th October 09 to 5th November 09. This colour would
indicate a warning to the coordinator that training will be required soon.
All dates that are within the 10 month time period, would remain white in
colour
Hopefully I've helped explain what I'm after and a few tweaks would be all
thats necessary to resolve this.
Many thanks for everyones input so far
Manxy
=======================================
7/18/2009 5:34 AM PST
Hi Jacob, thank you for showing me the step by step order as this is hugely
appreciated and probably for others who read this.
Being the 19th of June 2009 today and using the cells D3 to D48
I checked the cells using different dates and it came up with this:
2008 dates and upto the 18 Jul 09, there was no colour
19th July 09 only, there was 1 date only and coloured red
20th July 09 to 18th August 09 the colour was orange
19th August 09 to 18th September 09 the colour was yellow
19th September onwards, there was no colour
This is on the right track for what I require using excel
Basically, if I enter an old date say 6th Dec 08, that particular person
would be in date till 5th december 09, but on the 6th December, their
background of the date would turn red to indicate he is now out of date and
remain so until a fresh date has been entered.
Using the above date of 6th December 08, the background colour would be
orange if there was a 1 month gap between 6th November 09 to 5th December 09.
This colour is to indicate that the person needs to be retrained quickly so
that they remain indate
Again using the date entered of 6th December 08, I would like the background
colour to be yellow from 6th October 09 to 5th November 09. This colour would
indicate a warning to the coordinator that training will be required soon.
All dates that are within the 10 month time period, would remain white in
colour
Hopefully I've helped explain what I'm after and a few tweaks would be all
thats necessary to resolve this.
Many thanks for everyones input so far
Manxy
=======================================