freeze borders and shading
 

How can I freeze border and shading layouts without freezing the cell itself
completely. When pulling down/copy cell formulas etc it also copies the
layout (border and shading) in most cases its fine but quite irritating if
you have different shadings and or borders and have to fix it all over agian.

W

freeze borders and shading
 

Found Solution with conditional formatting for either rows or columns
=MOD(ROW()2)

automatically updates format either when inserting or deleting rows columns
etc

W

freeze borders and shading
 

I guess that you intended to say =MOD(ROW(),2) ?
--
David Biddulph

"willem" wrote in message
...
Found Solution with conditional formatting for either rows or columns
=MOD(ROW()2)

automatically updates format either when inserting or deleting rows
columns
etc

W