Hi all

I have 100+ clients on excel, all have certain certificates with different
expiry dates.

What I would like is either of the two.

1: The to highlight in red say if the expiry date is within 30-60 days of
todays date.
2: Have a seperate worksheet available whereby it will update automatically
with the name and certification that will expiry and of course when.

Obviously the reason for this is to ensure I remain compliant and chase
those candidates with soon to expire qualifications.

Thanks in advance :)
G