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