There is not a limit to the amount of colors you can add to a BOM.
a couple tricks: copy function
recording
if a component doesn't have a color variant add n/a in recording
The "Copy" function in the variant cell only works for components that have variants assigned to them. If you have a component that maybe doesn't have a specific color or variant, we would recommend creating a color variant of "N/A" so you can use the copy across function.