conditional formatting

[dhruvipanchal88]

Hi

I am trying to conditional formatting for top 5 values in each calculated column.

I'm using background color expression if(rank(sum([Roadway Clearance Time])) <= 5 ,RGB(183,255,255)) but not giving correct output.

Can any one suggest? I have attached table here.

[sidhiq91 · Accepted solution]

@dhruvipanchal88  Could you please use the below expression,

if(Aggr(rank(RoadwayClearanceTime),MaintenanceShed)<=5,RGB(183,255,255))

If this resolves your issue, please like and accept it as a solution.

[dhruvipanchal88]

It worked. Thank You @Sidhi91