Good Morning All,

I've got a workbook that has a couple of worksheets.

I have conditional formatting set up on all cells in the range F8 to AC47 which turns red if the date entered is over 6 months old.

As the first tab 'Section 1' will load up first and people won't always go into the second worksheet 'Section 2' I wanted to apply code to ws 'Section 2' so that the tab colour changes to red if any of the cells within the range F8 to AC47 are red due to the conditional formatting applied on them.

Basically so that it alerts the user that the second worksheet needs action as something is over 6 months old and so now 'out of date' so to speak.

And then the code would then make the tab colour go 'no colour' again once the red cell has been resolved and there are no red cells in the range F8 to AC47 again.

Any help would be much appreciated as I've been trying all sorts of coding but can't quite get it right.

Thanks
DC