Conditional Formatting every other date in a range

Hello,

I found this conditional formatting formula to highlight every other date range in rows on my worksheet.

=ISEVEN(SUM(1/COUNTIF($A$2:$A2,$A$2:$A2)))

=$A$2:$K$10000

But with close to 10,000 rows, the formula slows down the worksheet too much.

Is there another way to accomplish without the worksheet slowing?

I appreciate any help.

Thank you,
Nick

Maybe you could put that formula in a column to the right of K (e.g. in M2, copied down), and then your CF formula only needs to refer to $M2:

=$M2

(which is either TRUE or FALSE), still applicable to the range $A$2:$K$10000.

Hope this helps.

Pete

Great idea Pete, that worked.

Ludwig, the formula you posted is for every other row, thanks for the input though.

Glad to have helped - thanks for the rep.

Pete