I created a spreadsheet where there are different sheets that link to a composite.
However, for example: On sheet number 1 I changed the conditional formatting to shade yellow if a value is out of wrong. If I want to update the conditional formatting for 30 more sheets, how would I do this?
I tried deleting them and copying sheet number 1 30 more times, and that messed up the linking. I tried copying sheet number 1 over the rest, and it didn't update the conditional formatting.
Any thoughts?
Sample Sheet Master.xlsx
Bookmarks