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

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

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