here is the problem I have. I'm trying to condition format a few different lines. As it stands now it will go across the spreadsheet until a zero value is found, however I would like it to keep going 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 the word "cumulative"