1 of 1 people found this helpful
one way would be to use a discrete pallet -
the formula I used is
the values were just arbitrary - you know your data and can select whatever makes sense
then place the formula on the color tile and edit the color - double click each color
and select from the advanced coor selection
it returns this
it is quite incredible that we have to make such a workaround for a simple task like that, isn't it?
Anyway thanks a lot, your solution worked for me!
if this solved you problem please mark the initial response correct to close the thread