Formatting in Excel
 

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!

Formatting in Excel
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Century12" <u21889@uwe wrote in message news:604bb3f46ea8d@uwe...
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!

Formatting in Excel
 

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


Bernard Liengme wrote:
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!

Formatting in Excel
 

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


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


"Century12" <u21889@uwe wrote in message
news:604cb17cf0ff1@uwe...
This does not give me the ability to alternate colors. What am
I doing wrong?


Bernard Liengme wrote:
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!

Formatting in Excel
 

Thank you... it worked like a charm!

Chip Pearson wrote:
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]

Thanks!