Forum Discussion
BaltaD
Mar 23, 2026Copper Contributor
Excel Tables and Conditional Formatting
I am trying to format my data by either creating a table or conditional formatting. The data has a common Team ID number with different amount of players. If I create a table, this is what I ge...
Riny_van_Eekelen
Mar 23, 2026Platinum Contributor
Worked on something like this a long time ago and can't remember if I made this up myself or found it somewhere on-line. Anyway, I now found it in my saved example files and share it here.
The CF formula I would use to color the rows based in the team number in column B is this:
=MOD(SUM(IF(FREQUENCY($B$2:$B2,$B$2:$B2),1)),2)
Can't upload the file. The system is a bit screwed lately. Therefore just a picture.