freeze borders and shading

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
 
W

willem

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

freeze layout 1
locking in borders and shading? 2
Any way to freeze cell format? borders, shadding, fonts ... 2
Copying cell border formatting, without shading. 3
Applying partial borders to text not to paragraph 6
Tables need menu commands to clearly define internal and external. 2
Word 2002 on XP complains about Borders, on Win 98 no complaint. 2
Shared borders, navigation and hit counters disappear 10

Top