Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Auto-Format Cell Shading

Excel 2003

How do I cause a cell's shading color on one worksheet to automatically
reflect the same color as a specific cell on another worksheet within the
same workbook? I want the shading color only, no data.

The objective is an "at-a-glance" status report worksheet so that we do not
need to flip between worksheets to find the status of publication updates
distributed to all personnel.



  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default Auto-Format Cell Shading

You can't do that with any built-in feature in Excel.

If the color coding in the specific cell is based on a condition, you can
apply conditonal formatting.

You can also write a vba macro to do the formatting.

We would need to know more about your data layout and the "specific cell" to
give you more details. Why would the color in that cell change, in other
words the condition for the cell color (and what possible colors can the cell
take for what condtions).

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Crazyhorse75" wrote:

Excel 2003

How do I cause a cell's shading color on one worksheet to automatically
reflect the same color as a specific cell on another worksheet within the
same workbook? I want the shading color only, no data.

The objective is an "at-a-glance" status report worksheet so that we do not
need to flip between worksheets to find the status of publication updates
distributed to all personnel.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Auto-Format Cell Shading

This is a very simple spreadsheet with no formulae. It is being used to
track revision status for publications that receive updates at random times
throughout the year. The layout is essentially a name with revision numbers
and effective date being a double header to each column:
Rev # 01-2009 02-2009 03-2009
Effective Date 1/6/09 1/30/09 4/21/09
Doe, John X X
Smith, Snuffy X
Aircraft # 670 X X X

An X is currently used to indicate that person has signed for their revision
(what is used to mark is arbitrary, 1's could be used if we were using a
formula) and I'm manually coloring the cell containing the name to indicate
fully up to date, or one-or-more changes behind.

Once I color that cell, I want that shading reflected on a cell next to
their name on a "status" sheet so that command can see the status of
personnel and aircraft publication revisions. Alternately, we could make the
name cell on the status sheet reflect the color but currently those cells
reflect a coding showing what unit those personnel and aircraft are assigned
to.

I am open to any alternative ideas how to achieve the goal and save me
having to manually color every cell on the status page.


"Shane Devenshire" wrote:

You can't do that with any built-in feature in Excel.

If the color coding in the specific cell is based on a condition, you can
apply conditonal formatting.

You can also write a vba macro to do the formatting.

We would need to know more about your data layout and the "specific cell" to
give you more details. Why would the color in that cell change, in other
words the condition for the cell color (and what possible colors can the cell
take for what condtions).

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Crazyhorse75" wrote:

Excel 2003

How do I cause a cell's shading color on one worksheet to automatically
reflect the same color as a specific cell on another worksheet within the
same workbook? I want the shading color only, no data.

The objective is an "at-a-glance" status report worksheet so that we do not
need to flip between worksheets to find the status of publication updates
distributed to all personnel.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-format shading color. John Excel Discussion (Misc queries) 2 August 18th 06 10:57 PM
Conditional Cell Shading (based on the shading of other cells) Tubby Excel Worksheet Functions 2 June 20th 06 10:03 PM
Excel Auto-Format cell to email format Please Help Me Excel Discussion (Misc queries) 1 March 23rd 06 05:15 PM
Auto shading Jock W Excel Worksheet Functions 3 August 8th 05 05:43 PM
how do you set auto shading of cell based on percent value in exc. d.rogers59 Excel Worksheet Functions 3 February 12th 05 08:25 AM


All times are GMT +1. The time now is 12:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"