| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-format shading color.
How do I change the color of the auto-format every other line shading from
grey to a different color in Excel? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto-format shading color.
John wrote:
How do I change the color of the auto-format every other line shading from grey to a different color in Excel? 1. Format, Cells, Pattern - take mental note of which grey is being used 2 Tools, Options, Color - click on the grey colour. Modify, and slide the grey up or down - or select another colour -- Message posted via http://www.officekb.com |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto-format shading color.
John
The autoformat shading doesn't stick if you delete rows or sort the data. Better to use Conditional Formatting which doesn't get messed up. Select a range of rows to format. FormatCFFormula is =MOD(ROW(),2)=1 Pick a color from FormatPatterns and OK your way out. Gord Dibben MS Excel MVP On Fri, 18 Aug 2006 06:22:01 -0700, John wrote: How do I change the color of the auto-format every other line shading from grey to a different color in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel table auto format total row should see sum formula already | Excel Worksheet Functions | |||
| format cells for color | Excel Worksheet Functions | |||
| Which Excel version has the slide transparency in format auto shap | Excel Discussion (Misc queries) | |||
| Conditional Format -- shading ten fields in a row reacting to colu | Excel Discussion (Misc queries) | |||
| Is there a way to change the default shading color ? | Excel Discussion (Misc queries) | |||
Linear Mode
