Conditional Formatting

[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.

 

[FSt1]

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

 

[T. Valko]

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

 

[Nadine]

got 15 worksheets to copy them across too.... paste special was taking just
as long as recreating them. Different columns with different conditions.