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?