ExcelBanter - Cell Shading

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

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

- - Cell Shading (https://www.excelbanter.com/excel-discussion-misc-queries/81742-cell-shading.html)

viper2000ss

Cell Shading

How do I keep every other row shaded when I sort data?

Jonathan Cooper

Cell Shading

see posting on this topic, earlier today.

select the rows you want shaded. go to conditional formatting.
formula....=mod(row(),2) and select the shading color you want.

"viper2000ss" wrote:

How do I keep every other row shaded when I sort data?

All times are GMT +1. The time now is 03:52 AM.