Coloring the Max and Min Values in Pivot Table Rows with Multiple Dimensions

[dmoreno2605]

Hi everyone, i need your wisdom, i have the following table:

Puesto	Menos de 3 meses	3 a 6 meses	6 a 12 meses	1 a 2 años	2 a 3 años	Mas de 3 años
Chofer	39	14	18	24	11	4
Gerente de Distrito	2	1	4	6	3	3
Gerente de distrito en formacion	0	1	0	0	0	0
Gestor Cobranza	10	16	20	41	20	4
Gestor Ventas	10	27	16	39	12	2
MGRNTRN	4	5	2	1	0	0
MIT	2	2	0	0	1	0
MSTRMGR	12	3	13	42	18	15
Rep Cobranza	91	60	69	49	14	1
Rep Ventas	89	57	68	53	14	1
Total	259	186	210	255	93	30
Total %	25.07%	18.01%	20.33%	24.69%	9.00%	2.90%

I need to color the max value as green and the min value as red of each row, the problem is when i have two max values or two min values, in those situations it will not color, how can i color both or choose one to color? Any ideas?

Thanks!

[rwunderlich]

Are you using a color expression?  If so, can you post it?

-Rob

[dmoreno2605]

Sorry i took my time
i;m using this for each column
if(Column(2)>Column(1) and
Column(2)>Column(3) and
Column(2)>Column(4) and
Column(2)>Column(5) and
Column(2)>Column(6),Green(),
if(Column(2)<Column(1) and
Column(2)<Column(3) and
Column(2)<Column(4) and
Column(2)<Column(5) and
Column(2)<Column(6),rgb(255, 0, 0)))

[rwunderlich · Accepted solution]

When you have a tie, your > or < test will never be try.  So change your operators to >= and <=.

Also, you could write more compact using RangeMax:

if(column(2) >= RangeMax(column(1), column(3),...)