Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |