Exel Spreadsheets

[Guest]

Hi
I have multiple exel spreadsheets containing data on staff and their competency with in specific areas of their work which requires me to update their skills on a 6monthly basis. Is there a way to programme exel to automaticly display those staff requiring reassessment in a particular month rather than me trawling through the spread sheets individually

Thanks for your hel
Denise

 

[Bob Phillips]

Denise,

Use conditional formatting.

Assuming the dates are in A1:An, select all of those cells.
Goto Format>Conditional Formatting
Change Condition1 to Formula Is
Add this formula
=A1<=DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY()))
Click Format and select a pattern colour
Exit out

Dates older than 6 months will show in that colour

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi
I have multiple exel spreadsheets containing data on staff and their

competency with in specific areas of their work which requires me to update
their skills on a 6monthly basis. Is there a way to programme exel to
automaticly display those staff requiring reassessment in a particular month
rather than me trawling through the spread sheets individually.

 

[Nikos Yannacopoulos]

Denise,

Almost anything can be done through VB, but in your case it's kind of an
overkill, when all that's required is to use the Autofilter function (Data >
Filter > Autofilter) and filter on your date column.

HTH,
Nikos

Hi
I have multiple exel spreadsheets containing data on staff and their

competency with in specific areas of their work which requires me to update
their skills on a 6monthly basis. Is there a way to programme exel to
automaticly display those staff requiring reassessment in a particular month
rather than me trawling through the spread sheets individually.