Colour Rows If Condition = x

[cossie2k]

Hey all,

I hope everyone is OK.

I currently have a macro that works fine

Please Login or Register  to view this content.

I want to repeat the process again for the "Old" tab so thought I could do this

Please Login or Register  to view this content.

This doesnt work though and states that the "For control variable is already in use". If I remove the For Each from my new bit it states "Next without For".

Can anyone tell me where I am going wrong?

Thanks for all your help,
Alex

[cossie2k]

Proudly managed to fix it myself!

Please Login or Register  to view this content.