| Home |
| Search |
| Today's Posts |
|
#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! |
| 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 | |||
Threaded Mode
