I know I can use the F4 command and it will copy the last entry. The problem is I need to copy an entire sheets background color only once I have created my template in excel. I created a template with many different different background colors. So I would like to be able to click on an entire sheet and copy just the background colors and paste it into another sheet with different calculations. I tried to make just a template of the colrs but when I copy and paste it the data is deleted and replaced with the colors only.
Thank you :-)
John