I have a workbook with 300+ conditional formatting rules set up (reason for so many rules is due to a variance in targets). They are 3 colours red / amber / green.
I now need to change the colours to different shades is it possible to create a VB code which can change this?
Kind Regards
Bookmarks