here is the problem I have. I'm trying to condition format a fe
different lines. As it stands now it will go across the spreadshee
until a zero value is found, however I would like it to keep goin
until it reaches a non integer value.

for example:

Jan Feb Mar Apr Jun Jul Aug Sep Oct Nov Dec YTD Calctype
25 50 21
96 cumulative


so I would like the macro to check all the values until it reaches th
word "cumulative

--
evil bab
-----------------------------------------------------------------------
evil baby's Profile: http://www.excelforum.com/member.php...fo&userid=3198
View this thread: http://www.excelforum.com/showthread.php?threadid=51784