Create column with unique fill & text colours

[Damo10]

Hi,

I have a gant chart to show differnet base types and time used, the trouble i have now is that i have lot of different bases and some of the colours have been duplicated.

Is there a way of creating a column with 100 different colours/shades and different text colours?

any help would be great

Regards,

Damian