ExcelBanter - Shade alternate lines

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Shade alternate lines (https://www.excelbanter.com/excel-discussion-misc-queries/2040-shade-alternate-lines.html)

wyattf

Shade alternate lines

How can you shade alternate lines on a worksheet in order to make the result
more readable?

Peo Sjoblom

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?

Frank Kabel

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?

Martin P

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?

All times are GMT +1. The time now is 06:14 AM.