Conditional formatting min, mid and max value

[motilulla]

Hello,

I need to highlight cell depending on min, mid and max value in 3 different colours. Is it possible to with conditional formatting?

Like this...

Book1
	D	E	F
4	15	52	45
5
6	12	4	40
7
8	0	5	10
9
10	10	2	9
Sheet1

Thank you all
Excel 2000
Regards,
Moti

 

[stumac]

I think you would need to set up 3 rules, based on your sample data:

Select the cells D4:D10 and add the following rules (use a formula to determine which cells to format):

=AND(D4<>"",D4=MIN($D4:$F4))
=AND(D4<>"",D4=MAX($D4:$F4))
=AND(D4<>"",D4=MEDIAN($D4:$F4))

 

[motilulla]

I think you would need to set up 3 rules, based on your sample data:

Select the cells D4:D10 and add the following rules (use a formula to determine which cells to format):

=AND(D4<>"",D4=MIN($D4:$F4))
=AND(D4<>"",D4=MAX($D4:$F4))
=AND(D4<>"",D4=MEDIAN($D4:$F4))

Hello stumac,

That's worked perfectly, thanks so much for your help

Regards,
Moti