View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Crazyhorse75 Crazyhorse75 is offline
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.