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?
|