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.
|