Ok So I'm not even sure if this is in the right forum
but If you take a look at the sheet you will see what I'm trying to do, I have conditional formatting in both the "office based competency" sheet and " track based competency" sheet where the dates of competence expiry change the cell colour based on how far away the date is from Today( ) etc. Joe Bloggs is the example name I have left in.
What I would like to do is change the cell colour containing Joe Bloggs name, to either White All competencies in date, yellow all in date but some within 60 days of Today () or Red Some due to expire within 30days though some maybe in date or within 60 days ie red is the final colour.
I would like to do this on both the Office and track competence sheet and I assume the same formula / conditional formatting would apply over the ranges E26:AF26 for the office sheet and then E27:AM27 Track based Competency sheet.
But the main thing is to give a view of these impending renewals on the Overview sheet. where Joe Bloggs cell colour would remain white or either fill red or yellow again either based on the previous ranges or perhaps using Vlookup to check the cell colours on the other 2 sheets Cells A26 and A27..
Sorry for the long winder post I've hit a wall applying it over a range and comparative range lol
Any help appreciated