Excel Help

Closed
davidandrew23 Posts 2 Registration date Wednesday 3 March 2010 Status Member Last seen 3 March 2010 - 3 Mar 2010 à 13:29
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 3 Mar 2010 à 15:15
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
3 Mar 2010 à 15:15
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