Formatting in Excel

[Century12]

I have set up an excel file in which I have colored every other line grey. I
would like to keep this formatting so that when I go to insert cells that it
automatically colors them the correct color and changes the others so that
it's clear, grey, clear, grey, etc.

Any hints????

Thanks!

 

[Bernard Liengme]

Use Format|Conditional Formatting rather than 'hard" colours.
Select the range of row to format and use
Formula Is =MOD(ROW(),2)=1 and select some pattern colour
best wishes

 

[Century12]

This does not give me the ability to alternate colors. What am I doing wrong?

Use Format|Conditional Formatting rather than 'hard" colours.
Select the range of row to format and use
Formula Is =MOD(ROW(),2)=1 and select some pattern colour
best wishes

I have set up an excel file in which I have colored every other line grey.
I

[quoted text clipped - 6 lines]

Thanks!

 

[Chip Pearson]

See www.cpearson.com/excel/banding.htm for examples.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

This does not give me the ability to alternate colors. What am
I doing wrong?

Use Format|Conditional Formatting rather than 'hard" colours.
Select the range of row to format and use
Formula Is =MOD(ROW(),2)=1 and select some pattern colour
best wishes

I have set up an excel file in which I have colored every
other line grey.
I

[quoted text clipped - 6 lines]

Thanks!

 

[Century12]

Thank you... it worked like a charm!

See www.cpearson.com/excel/banding.htm for examples.

This does not give me the ability to alternate colors. What am
I doing wrong?

[quoted text clipped - 9 lines]