I've set up a number of worksheets that collate data from a number of
sources. For readability, we use background colours to code the information
entered in the cells. This information is extracted to a number of summary
report sheets. However, I can't find a way of getting the summary sheet to
acknowledge the background colours - it only transfers the text. Can anyone
help?

Chip has good stuff on colours: www.cpearson.com
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Alicat" wrote in message
...
I've set up a number of worksheets that collate data from a number of
sources. For readability, we use background colours to code the
information
entered in the cells. This information is extracted to a number of summary
report sheets. However, I can't find a way of getting the summary sheet to
acknowledge the background colours - it only transfers the text. Can
anyone
help?