Conditional Formatting

  • Thread starter Thread starter Nadine
  • Start date Start date
N

Nadine

Excel 2003

Can't select multiple worksheets at same time and use the conditional
formatting tool. Is there a simple way of copying the conditional formatting
to the other worksheets? Besides the format painter option.
 
hi
not sure how much you have to copy but conditional formats can be copied and
pasted just like any other format even paste special > formats only.

regards
FSt1
 
Apply the format on one sheet. Assume the cell formatted is A1.
Select cell A1
Goto the menu Edit>Copy
Then navigate to your other sheet selecting cell A1
Goto the menu Edit>Paste Special>Formats>OK
 
got 15 worksheets to copy them across too.... paste special was taking just
as long as recreating them. Different columns with different conditions.
 
Back
Top