freeze borders and shading

  • Thread starter Thread starter willem
  • Start date Start date
W

willem

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
 
Back
Top