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.

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

On Jan 18, 9:32*am, Lamar wrote:
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.

Lamar

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

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

FormatCFFormula is: =MOD(SUBTOTAL(3,$A1:$A$2),2)=1

FormatPattern. Pick the gray you want and OK your way out.


Gord Dibben MS Excel MVP


On Thu, 17 Jan 2008 16:32:02 -0800, Lamar
wrote:


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.