highlight min/max values in straight table

[#1]

Hi all,

I want to highlight min/max values in a straight table for each column.

how can I do it?

Thanks,

Boris

[swuehl · Accepted solution]

Try a background color expression attribute (on expression tab, open the attributes by clicking on the plus sign next to the expression label), something like

if(rank( EXPRESSION) = 1, lightgreen(),

if(rank( -EXPRESSION) = 1, lightred()

)

[babitaku]

For Maximum value, results are coming right but to highlight minimum results are not coming.

I am using below expression:

If(rank(Total Salary)=1,Green(), ---Correct
If(rank(-Total Salary)=1,Yellow())) ---Not Correct

Any Help would be appreciated!

Babita

[Majed]

I prefer using a simpler way

if (rank (column(1)) =1, Green()
,if (rank (-column(1)) =1, red()
))

where column(n) is the number of the column, counting measures only.