It's been unbelievable that excel still has not include this feature as a command. Alternate row's shade can lead to much easier reading through lines. Anyway, here is the way.
http://www.techonthenet.com/excel/questions/cond_format2.php
The idea is use conditional format for formula =mod(row(),2) = 1 and apply the shade you want for the case = 1.
:)
No comments:
Post a Comment