in tableau when you mention 'green', 'red' , tableau couldn't identify them as colors.
when you drag that calculated field onto color, it assigns unique colors for each condition with name you specified.
This is why it is showing wrong colors and names in Pooja's color palatte(ex: Green for Blue)
you have to hover over AGG(Cal1)(taking above example) and select "edit colors" and assign correct colors to the names mentioned in calculated field.
Hope this solves your problem.
I know its a old thread...but I have a question over the same.
As in the screenshot above, can I get the colors in the background of the 'City' column as well.
For e.g. 'Aberdeen' cell should turn green as well.
Hope I am clear...:)
Thanks and Regards,