Forum Discussion
Solved
How to alternate table row colour based on the contents of a cell within the row
Hi, I am wanting to add in conditional formatting to my table so that the row colour alternates when the contents of one of the row's cells changes... E.g. How do I get the row colour ...
Use the following formula in the conditional formatting rule:
=MOD(ROUND(SUM(1/COUNTIF($A$2:$A2,$A$2:$A2)),0),2)
Use the following formula in the conditional formatting rule:
=MOD(ROUND(SUM(1/COUNTIF($A$2:$A2,$A$2:$A2)),0),2)
