Multiple conditional formatting

[ExcelRoy]

Hi all,

i have a worksheet i have used for some time now and have expanded to multiple data sets and reporting

I have used conditional formatting and copied this data throughout the development of the sheet

Is there any way i can change all conditional formatting on each tab to one type of cell border colour rather than click through each set of data (approx 350 sets of data)

Many thanks

 

[pbornemeier]

You could use VBA to read each worksheet and modify the conditional formatting found on it. It may take some trial and error and I would definitely test the code on a backup copy. Use the macro recorder to copy a typical conditional formatting then use it again to show the typical plus the desired additional formatting.