| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro To Shade Every Other Row
I have the following Range: "A10:Z2000". I am trying to figure out some
code that would allow me to begin with row 10 within the range, and highlight every other row with a light shade of grey until it reaches the end of the range. Some of the cells will have other formats in place (Number, Percentage, etc), so I would want the shading to occur with the existing formats remaining in place. Can anyone help. Thanks. Jason |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| shade one cell that will shade multiple cells | Excel Discussion (Misc queries) | |||
| add days and shade help | New Users to Excel | |||
| shade cells | Excel Discussion (Misc queries) | |||
| How to shade every third row? | Excel Discussion (Misc queries) | |||
| Shade Every Other Row | Excel Discussion (Misc queries) | |||
Threaded Mode
