Friday, May 9, 2014

Interleave row's shade

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.

Microsoft Excel

:)

No comments:

Post a Comment