Copying formatting

  • Thread starter Thread starter Richard Cavell
  • Start date Start date
R

Richard Cavell

Hi.

If I had the value '5' in cell A1, I could put that in cell A2 by
typing '=A1' in cell A2. Then if I change cell A1, A2 changes
automatically.

I want to be able to do the same thing with formatting rather than
values (especially background colour, border and so on).

Is there a way?

Richard
 
Formulas don't retrieve this kind of formatting.

You could have a macro that copy|pastes that does the work, though.
 
Back
Top