How?

MOD(30,2)=0
MOD(31,2)=1

Biff

"CaptainQuattro"
<CaptainQuattro.27xv42_1147847423.0779@excelforu m-nospam.com wrote in
message news:CaptainQuattro.27xv42_1147847423.0779@excelfo rum-nospam.com...

If you use Mod(day... you will get two adjacent same-coloured rows at
the end of a month with 31 days.


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile:
http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=542781