Forum Discussion

BaltaD's avatar
BaltaD
Tin Contributor
Mar 23, 2026

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...
excel
IlirU's avatar
IlirU
Iron Contributor
Mar 23, 2026

Hi BaltaD​,

Select range A3:G32 and in CF apply below formula:

=MOD(XMATCH($B3, UNIQUE(TOCOL($B$3:$B$32, 1))), 2) = 1

Format with the color you want.

HTH

IlirU