Copying formatting

[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

 

[Dave Peterson]

Formulas don't retrieve this kind of formatting.

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