| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting lost when saving excel 2003 file using excel 2007 | Excel Discussion (Misc queries) | |||
| "Excel encountered an error and had to remove some formatting toavoid corrupting the workbook. Please re-check your formatting carefully." | Excel Discussion (Misc queries) | |||
| Saving Excel 2007 conditional formatting in Excel 2003 format | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Linear Mode
