| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Shade alternate lines
How can you shade alternate lines on a worksheet in order to make the result
more readable? |
|
#2
|
|||
|
|||
|
One way
http://www.cpearson.com/excel/banding.htm Regards, Peo Sjoblom "wyattf" wrote: How can you shade alternate lines on a worksheet in order to make the result more readable? |
|
#3
|
|||
|
|||
|
Hi
see: http://www.cpearson.com/excel/banding.htm -- Regards Frank Kabel Frankfurt, Germany "wyattf" schrieb im Newsbeitrag ... How can you shade alternate lines on a worksheet in order to make the result more readable? |
|
#4
|
|||
|
|||
|
Conditionally format cell A1 with Formula is =INT(ROW(A1)/2)<ROW(A1)/2,
choose a pattern and copy the format to the entire worksheet. "wyattf" wrote: How can you shade alternate lines on a worksheet in order to make the result more readable? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I shade the area between two lines on a chart? | Charts and Charting in Excel | |||
| Excel Connector Lines | Charts and Charting in Excel | |||
| How to force continuous lines in line charts | Charts and Charting in Excel | |||
| Bold Grid Lines | Excel Discussion (Misc queries) | |||
| How do I shade alternate rows in Excel 2002? | Excel Discussion (Misc queries) | |||
Linear Mode
