Lock formatting

[Ghais Chatila]

Hello,

I have a spreadsheet that I modify often (change values, delete rows, etc.) in Excel 2007

Is there a way to keep the shading of cells (alternate rows of white/grey) even if i delete a row completely?

Thanks a lot.

 

[VoG]

Try Conditional Formatting to shade the rows http://www.contextures.com/xlCondFormat03.html#Shade

 

[Ghais Chatila]

Thanks for the quick response.

I forgot to mention that I need to shade only a few selected cells in each row (consistent throughout the column) in the same manner that I explained before.

 

[VoG]

So you would apply the CF to just those columns.