Conditional format question

[PeCoNe]

Hallo,

Row A contains the month numbers.
Row B contains the month totals obtained by a vlookup.
I want that the lowest total colors green and
that the highest total colors red.
Only the past months are filled.


Month 1 2 3 4 ... 12
Total 100.00 98.00 45.00 300.00

How looks my conditional format formula

Thanks Peter Maljers

 

[Claus Busch]

Hi Peter,

Am Thu, 25 Apr 2013 22:28:14 +0200 schrieb PeCoNe:

Month 1 2 3 4 ... 12
Total 100.00 98.00 45.00 300.00

select B2:M2 => Conditonal formatting =>
Formula for Min:
=AND(B2<>"";B2=MIN($B$2:$M$2))
Formula for Max:
=B2=MAX($B$2:$M$2)


Regards
Claus Busch

 

[PeCoNe]

Op 2013-04-26 09:37, Claus Busch schreef:

Hi Peter,

Am Thu, 25 Apr 2013 22:28:14 +0200 schrieb PeCoNe:


select B2:M2 => Conditonal formatting =>
Formula for Min:
=AND(B2<>"";B2=MIN($B$2:$M$2))
Formula for Max:
=B2=MAX($B$2:$M$2)


Regards
Claus Busch

Hi Claus,

The last formula used is:
=E3=KLEINSTE($D$3:$Q$3;AANTAL.ALS($D$3:$Q$3;0)+1)

The values can also be negative, so how do i change the formula to
support numbers < 0.

Bye Peter

 

[Claus Busch]

Hi Peter,

Am Wed, 01 May 2013 17:32:15 +0200 schrieb PeCoNe:

The last formula used is:
=E3=KLEINSTE($D$3:$Q$3;AANTAL.ALS($D$3:$Q$3;0)+1)

The values can also be negative, so how do i change the formula to
support numbers < 0.

try:
=B2=IF(MIN($B2:$M2)<0,MIN($B2:$M2),SMALL($B2:$M2,COUNTIF($B2:$M2,0)+1))


Regards
Claus Busch

 

[PeCoNe]

Op 2013-05-01 17:44, Claus Busch schreef:

Hi Peter,

Am Wed, 01 May 2013 17:32:15 +0200 schrieb PeCoNe:


try:
=B2=IF(MIN($B2:$M2)<0,MIN($B2:$M2),SMALL($B2:$M2,COUNTIF($B2:$M2,0)+1))


Regards
Claus Busch

thanks again, problem solved

Bye Peter