I have a number of sheets of individual data sets that are then rolled up onto a summary sheet.
How can I make the linked cells show the formatting as well as the data.
Manually replicating conditional formatting is tedious !
(and I though Manual Labor was a Spanish Tennis Player)