| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
autoformat add or change
Can you add a new auto format and/or change one. There is an autoformat
list1 that hilites every other row in light grey is there a way to make it a different color? list 2 is green, but it hilites every two rows. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
autoformat add or change
Roll your own using Conditional Formatting
Select a bunch of rows.....not cells, rows. FormatConditional FormattingFormula is: =MOD(SUBTOTAL(3,$A1:$A$2),2)=0 Format to your choice of color and hit OK Gord Dibben MS Excel MVP On Tue, 12 Jan 2010 08:01:01 -0800, bwilde wrote: Can you add a new auto format and/or change one. There is an autoformat list1 that hilites every other row in light grey is there a way to make it a different color? list 2 is green, but it hilites every two rows. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| autoformat | Excel Discussion (Misc queries) | |||
| Autoformat | Excel Worksheet Functions | |||
| autoformat a .csv file | Excel Discussion (Misc queries) | |||
| How can I create an AutoFormat row color change for a value in a c | Excel Worksheet Functions | |||
| How do I change the color scheme of the autoformat for table 2? | Excel Discussion (Misc queries) | |||
Linear Mode
