Conditional Formatting for rows...
 

Okay, I've already tried to ask this as a follow-up question, but I don't
think I was clear enough. I know how to color every other row now, which is
awesome, but while I would like the formatting to continue unending
vertically, I would like it to stop after column "E."

The formula I have in the conditional formatting box is =MOD(ROW()-1,1*2)+11
Is there something I can add to that to make the formula stop after E? If
so, exactly how might I write that/ where would I put it? Do I have to add a
separate condition or can I do it in the same one? I am not experienced at
ALL with using formulas in Excel except for simple calculating ones.

Any help would be greatly appreciated by this greenhorn.

Conditional Formatting for rows...
 

just select columns A:E and set the CF. It then won't apply to F on.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"dramajuana" wrote in message
...
Okay, I've already tried to ask this as a follow-up question, but I don't
think I was clear enough. I know how to color every other row now, which
is
awesome, but while I would like the formatting to continue unending
vertically, I would like it to stop after column "E."

The formula I have in the conditional formatting box is
=MOD(ROW()-1,1*2)+11
Is there something I can add to that to make the formula stop after E? If
so, exactly how might I write that/ where would I put it? Do I have to add
a
separate condition or can I do it in the same one? I am not experienced at
ALL with using formulas in Excel except for simple calculating ones.

Any help would be greatly appreciated by this greenhorn.