Conditional formating....

[#1]

Hi guys,

I need to apply conditional formating row wise. I am able to do it column wise.

My condition is to highlight the max and the min value in a row.

So can you guys suggest a way to implement it please?

Thanks in advance

[Anonymous]

Hi Rishikesh,

You can use following condition:

if(value=aggr(max(value),dimension),red(),

if(value=aggr(min(value),dimension),green(),black()))

Check out this, it might help you.

Regards

Nitin