This is true for the row B2:J2, so and so forth downward. If I were to delete the row, 3, then my conditional format goes bonkers... How can I keep the CF the same when I add/delete rows?

It shouldn't go bonkers, if your data and formulas are aligned and the row in your formula is the current row.

It will go "bonkers" if you have offset it by one row.

So, if you select all of column A, and enter the formula:

Code:

`[COLOR=#333333]=isODD($A2)[/COLOR]`

you will be off one row (because in selecting ALL of column A, the first cell is actually A1, not A2, so you are applying that first formula to cell A1).

Basically, here is the rule of thumb to follow:

When writing Conditional Formatting formulas against multi-cell selections, always write the formula as it applies to the

__very first cell in your selection.__
People often get in trouble when the first row is a header, so the first row that they want to apply it to is row 2, but they have selected row 1 (by picking the whole column).

You either need to start your selection in row 2 (not whole column), or adjust your formula.

You can still pick the whole column and have it not apply to row 1 by writing the formula like this:

Code:

`[COLOR=#333333]=AND(ISODD($A1),ROW()>1)[/COLOR]`

which will always evaluate to FALSE for row 1.