conditional formatting

[Leo77]

How to get this through conditional formatting, i want to give color coding depending on the sales target achieved 

Vehicle category	Sales target
Bikes	0>60 Green, 60>90 Yellow,>90 Red
Cars	0>30 Green,30>90 Yellow,>90 Red
Buses	0>40 Red,  60>90 Green,>90 Yellow
Autos	0>50 Yellow ,  50>90 Red,>90 green

[AronC]

@Leo77 You could use the code below and just change your  limits. Might be a nicer way. I would at least change each condition or limit to a variabel for easier use.

pick(match([Vehicle category],'Bikes','Cars','Buses','Autos'),
if(sum(Sales)>90,red(), if( sum(Sales)<60,green(),yellow()) ) //Put limits for Bikes here
if(sum(Sales)>8,blue(),green()), //Cars here
if(sum(Sales)>30,yellow(),green()), //etc
if(sum(Sales)<30,black(),green())
)

Hope it helps you out!