I have a sheet in excel that has 40 rows, with some information in each row,
A B
Nate 32
Bob 28
Cheryl 65
John 34
Candy 23
I have manually highlighted men in blue and women in pink. Now I would like to keep one sheet with this info updated, but I have other sheets where I want to have additional info in columns B. So In my next sheet I would like to have
A B
Nate Smith
Bob Smith
Cheryl Flores
John Candy
Candy --
The kicker, is that if I change Nate to Mary and format it pink in Sheet1 I want Sheet2 to reflect this, is it possible? I can get the data from the cell easily enough
Sheet1!A1
But this only gets the data, is there a way to copy the custom formatting (background color, borders etc)? I would rather have these things on different sheets to avoid horizontal scrolling like mad but if I can't I will go that route.