Thread: How do I keep color and border line formatting

How do I stop a cell's color formatting and border line formatting from being changed every time a cut and paste is done.

What I mean is I created a simple sheet and put nice colours in it and nice border lines in it. But when somebody cuts from a cell with orange formatting and pastes to a cell with blue formatting the colour is pasted as well as just the text. so i get a orange square in a blue section.

I have been looking everywhere for this answer and cant seem to find it anywhere. Probably staring me in the face! Any help would be greatly appreciated

Thanks!

Never thought of that!

However would it be possible to lock just the formatting in any way and still allow all editing of content? So that the template will always remain the same whatever someone does to it?

My colleagues will probably not remember to paste special and will continue to create havoc to my formatting!

Many thanks,

Chris.

Can you use this?

=MOD(ROW(A1),2)=0

Use this as a conditional format and set your cell (in this case cell A1) to the format you want it to be. Click OK to conditional format to save it.

Select the cell A1 and copy it.

Select all the cells under it you want to copy the conditional format to and click Paste Special and copy just the formats.

Now what ever format is in the cell you are copying from, Orange or whatever, will be over-ridden by the conditional format you set up.