This is a beginning (Conditional Formatting)
Blue: =MOD(SUBTOTAL(3;B$6:B4);2)=0
Green: =MOD(SUBTOTAL(3;B$6:B4);2)=1
Ola Sandström
+-------------------------------------------------------------------+
|Filename: Book4.zip |
|Download:
http://www.excelforum.com/attachment.php?postid=3440 |
+-------------------------------------------------------------------+
--
olasa
------------------------------------------------------------------------
olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
View this thread:
http://www.excelforum.com/showthread...hreadid=375075