Make Cells Mimic The Formatting Of One Cell

skoz55 · #1 11-09-2011, 07:40 AM

I use an estimating spreadsheet often and frequently have to change colors and style of specific cell all over the spreadsheet. They are the same cells every time, however they are not next to each other, so I have to individually select each cell.l

Is there a way to make specific cells follow the formatting of say A3? Then if I change the direction of font, or the color, or anything in A3, all the other cells will follow.

Thanks.

4thangel · #2 11-09-2011, 09:00 AM

If marco's are not a problem, you may go for the format painter in a macro. See attached. change format of the input cell and press the button
Hope this is helpfull

Paul

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to make cells shift down automatically	iffy	Excel	7	04-15-2013 08:06 AM
Copy table cell formatting across multiple cells / tables	pakistanray	Word Tables	2	10-31-2011 08:07 AM
How to combine different cells data in one cell?	Learner7	Excel	1	07-28-2010 12:07 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM
How can I make a cell color RED under the Today's date cell?	Learner7	Excel	2	07-08-2010 12:52 AM