Conditional formatting based on multiple conditions

Hi Anonymous

Can you try this?

Create a measure

Condition = MAXX(Ex_Format, 
   IF(Ex_Format[Cabin]="Business"&& Ex_Format[Seats] >10, 1,
        IF(Ex_Format[Cabin]="Business"&& Ex_Format[Seats] <=10,2,
            IF(Ex_Format[Cabin]="Economy"&& Ex_Format[Seats] <=10, 3,
                IF(Ex_Format[Cabin]="Economy"&& Ex_Format[Seats] >10 && Ex_Format[Seats]<=40, 2)))))

Here, 1 -> Green. 2-> Orange, 3-> Red.

and then do the conditional formatting like this:

your result will be like this:

Hope this is what you are looking for.

Thanks

Raj