View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DPeske DPeske is offline
external usenet poster
 
Posts: 1
Default 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?