Copying conditional formatting to all worksheets

[andrewb90]

Hello all,

I have a number a conditional formatting assigned in my "Thursday" worksheet while I am updating and when I go to update the other six identical worksheets for the other days I would like to be able to copy all of my conditional formatting as well instead of having to reenter all of it on each sheet. Is this possible?

Any help would be greatly appreciated.

Thanks,

Andrew

 

[markmzz]

Try this and tell us if work:

Select the region that contains conditional formatting, and use the command/button Copy.

Then select all the other identical spreadsheets (use the Shift or Ctrl key for help the selection).

Then, select the region that should contain conditional formatting in any of the identical worksheets selected, choose the Paste Special command, choose the option Formats and click OK.

Markmzz