Condiftional Formating IF>0

[Ian Mac]

I currently have:

=D6=MIN($D6:$N6)

I'd like to highlight the MIN() of a series if above 0.

I'm being really slow tosay and can't figure it out

thanks

[lenze]

How About

=AND(MIN($D$6:$N$6),>0)

[Ian Mac]

On 2002-04-24 07:05, lenze wrote:
How About

=AND(MIN($D$6:$N$6),>0)

there's no joy on that.

=AND(MIN($D$6:$N$6),>0)

wouldn't work anyway.
thanks for trying

[Aladin Akyurek]

On 2002-04-24 06:56, Ian Mac wrote:
I currently have:

=D6=MIN($D6:$N6)

I'd like to highlight the MIN() of a series if above 0.

I'm being really slow tosay and can't figure it out

thanks

Select the target range and cond format it with the following formula:

=D6=MIN(IF($D$6:$N$6,$D$6:$N$6))

Don't worry: Conditional Formatting will accept this formula.

Aladin

[lenze]

=AND(D6=MIN($D$6:$N$6),D6>0))

[Ian Mac]

On 2002-04-24 07:25, Aladin Akyurek wrote:

Select the target range and cond format it with the following formula:

=D6=MIN(IF($D$6:$N$6,$D$6:$N$6))

Don't worry: Conditional Formatting will accept this formula.

Aladin

Fantastic! but (there always is).

=D7=MIN(IF($D7:$N7,$D7:$N7)) work dandy,

BUT if a cell currently has a no value (0) the following doesn't work for it

=D7=MAX(IF($D7:$N7,$D7:$N7))

I'd like both to work if cell value is >0.

I would IF() the 0's out but I need them.

thank for the MIN() part though

[Aladin Akyurek]

On 2002-04-24 07:35, Ian Mac wrote:

Fantastic! but (there always is).

=D7=MIN(IF($D7:$N7,$D7:$N7)) work dandy,

BUT if a cell currently has a no value (0) the following doesn't work for it

=D7=MAX(IF($D7:$N7,$D7:$N7))

I'd like both to work if cell value is >0.

I would IF() the 0's out but I need them.

thank for the MIN() part though

Rearding MAX, if I understood you correctly, simpler

=AND(D7=MAX($D7:$N7),D7>0)

should work.

Aladin

Addendum:

=IF(SUM($D$7:$N$7),D6=MIN(IF($D$7:$N$7,$D$7:$N$7)))

will excude the case that D7:N7 is filled up with true zeroes and/or with blanks.

=AND(D6=MAX($D$6:$D$12),OR(D6>0,D6<0))

will cover all non-zero numbers.


[ This Message was edited by: Aladin Akyurek on 2002-04-24 08:11 ]

[Ian Mac]

On 2002-04-24 07:43, Aladin Akyurek wrote:

Rearding MAX, if I understood you correctly, simpler

=AND(D7=MAX($D7:$N7),D7>0)

should work.

Aladin

Addendum:

=IF(SUM($D$7:$N$7),D6=MIN(IF($D$7:$N$7,$D$7:$N$7)))

will excude the case that D7:N7 is filled up with true zeroes and/or with blanks.

=AND(D6=MAX($D$6:$D$12),OR(D6>0,D6<0))

will cover all non-zero numbers.


[ This Message was edited by: Aladin Akyurek on 2002-04-24 08:11 ]

Cheers Aladin, my brain isn't working but your formula is.