Conditional Formatting
 

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.

Conditional Formatting
 

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

"Nadine" wrote:

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.

Conditional Formatting
 

Apply the format on one sheet. Assume the cell formatted is A1.
Select cell A1
Goto the menu EditCopy
Then navigate to your other sheet selecting cell A1
Goto the menu EditPaste SpecialFormatsOK

--
Biff
Microsoft Excel MVP


"Nadine" wrote in message
...
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.

Conditional Formatting
 

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

"FSt1" wrote:

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

"Nadine" wrote:

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.