you may try something like:
Create calculated field:Color
If Sales then 1 else 0;
drag new filed "Color" to the colors mark.
Hope this helps!!
Can you please provide a sample data or twbx so that we can check requirement.
Below I have attached dummy workbook based on sample data. Please go through the same.
Thank You for the help in advance.
Sorry Amar this is not the thing which I want