ExcelBanter - Shaded for every other row

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

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

- - Shaded for every other row (https://www.excelbanter.com/excel-discussion-misc-queries/226062-shaded-every-other-row.html)

KrispyData

Shaded for every other row

Is there a way to format every other row as shaded (without manually doing
it)? And, for visible rows only?

FSt1

Shaded for every other row

hi
not sure but check this site out and see if that is not what you are after....
http://www.cpearson.com/excel/banding.htm

Regards
FSt1

"KrispyData" wrote:

Is there a way to format every other row as shaded (without manually doing
it)? And, for visible rows only?

KrispyData

Shaded for every other row

Perfect!
Thanks FSt1 !!

"FSt1" wrote:

hi
not sure but check this site out and see if that is not what you are after....
http://www.cpearson.com/excel/banding.htm

Regards
FSt1

"KrispyData" wrote:

Is there a way to format every other row as shaded (without manually doing
it)? And, for visible rows only?

All times are GMT +1. The time now is 08:59 AM.