I want to use conditional formatting to highlight every other GROUP of rows, not just every other row indiscriminately. I found online a formula to do it that way (=MOD(SUM(COUNTIF($A$2:$A2,$A$2:$A2)),2)=1"], but it is not working as anticipated. I would prefer not to create a True/False column in order to do this, nor VBA code. If someone could help me I would appreciate it.