Excel Help

Closed
davidandrew23 Posts 2 Registration date Wednesday March 3, 2010 Status Member Last seen March 3, 2010 - Mar 3, 2010 at 01:29 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 3, 2010 at 03:15 PM
Hello,

Say on sheet 1 I have in A1 the value 3 and the cell color is red. Is there a way to do a formula that would return this on sheet 2 in A1. if I do =Sheet!1A1 all I get is the 3. How can I also get the Red Cell Color?
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 3, 2010 at 03:15 PM
Not via formula. One of the two may help you

1. If all you want is to format one sheet, and have same formatting to pass thru the other sheets, then you can first select all the target sheet. Then apply format. It would be applied to all selected

2. You have to write macro to do that
0