Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically Copy formatting (I.E. shading)
I have a Workbook consisting of 3 worksheets. The first worksheet is use to
control the data presented on the remaining sheet. In order to highlight the revision of data, users currently shade the cells with revisions. I would like to have the cells that contain the shading to automatically apply shading to their corresponding sheets. Is this possible through a formula or do I have to create a macro (is so please help) in order to accomplish the task? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically Copy formatting (I.E. shading)
I assume sheets 2 and 3 use linking formulas to get their data from sheet1.
These will not pull formats along with data. Any way you might use Conditional Formatting of values? If not, either copy/paste formats or use VBA Give us an idea of which cells on sheets 2 and 3 would be linked back to which cells on sheet1. Gord Dibben MS Excel MVP On Mon, 27 Oct 2008 11:34:01 -0700, DPeske wrote: I have a Workbook consisting of 3 worksheets. The first worksheet is use to control the data presented on the remaining sheet. In order to highlight the revision of data, users currently shade the cells with revisions. I would like to have the cells that contain the shading to automatically apply shading to their corresponding sheets. Is this possible through a formula or do I have to create a macro (is so please help) in order to accomplish the task? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically Copy formatting (I.E. shading)
Hi,
Conditional Formatting can be done between sheet if you use Range Names. But conditional formatting can not be based on cell color, only on cell content. So it looks like a vba solution may be your only option. -- Thanks, Shane Devenshire "Gord Dibben" wrote: I assume sheets 2 and 3 use linking formulas to get their data from sheet1. These will not pull formats along with data. Any way you might use Conditional Formatting of values? If not, either copy/paste formats or use VBA Give us an idea of which cells on sheets 2 and 3 would be linked back to which cells on sheet1. Gord Dibben MS Excel MVP On Mon, 27 Oct 2008 11:34:01 -0700, DPeske wrote: I have a Workbook consisting of 3 worksheets. The first worksheet is use to control the data presented on the remaining sheet. In order to highlight the revision of data, users currently shade the cells with revisions. I would like to have the cells that contain the shading to automatically apply shading to their corresponding sheets. Is this possible through a formula or do I have to create a macro (is so please help) in order to accomplish the task? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting of cells in a locked worksheet. EG shading | Excel Worksheet Functions | |||
Cell shading with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting Shading For Visible Rows Only | Excel Discussion (Misc queries) | |||
how do I use conditional formatting for alternating cell shading? | Excel Worksheet Functions | |||
conditional formatting-shading | Excel Worksheet Functions |