Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
@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!