Cell Shading

[Lamar]

I have a spreadsheet where the even numbered rows cell shading is grey and
the odd rows cell shading is white. I use

I have numbers in my other columns where i.e. A2 is 001, A3 = 002, A4 = 003,
etc. I need to update those numbers so I change A2 to = 020 and click lower
right corner of cell to get the "+" sign and start to drag. So A3 = 021, A4
= 022, etc.

As drag all cell shading turns to grey or white depending where I start.
How to use this feature to change the number in the cell without it changing
the cell shading.

Thanks for any help.

 

[carlo]

Change A2 to 020 and A3 to 021
then select both and drag it down like you did before, that way excel
will alternate the shadings.

hth
Carlo

 

[Gord Dibben]

Lamar

Shade the rows using Conditional Formatting and the shading won't change as you
drag cells.

Select 1 xouple hundred rows then.............

Format>CF>Formula is: =MOD(SUBTOTAL(3,$A1:$A$2),2)=1

Format>Pattern. Pick the gray you want and OK your way out.


Gord Dibben MS Excel MVP