conditional formatting bug?

[joemeshuggah]

curious to know what might cause this...

=MIN($F$10:$F$17,$F$19:$F$22)

this is the formula i am using for a conditional format (the min value is
highlighted in red)...i pasted special formats for F10:F23.

cell F18 (not in the range specified in the formula above) is equal to cell
F16 (in the range specified in the formula) which happens to be the minimum
value, and for some reason cell F18 is also highlighting along with F16.
oddly, if i change the value for cell F18 to a number lower than F16, the
highlighting in cell F18 disappears and F16 remains highlighted (as it
should).

is this a bug in excel?

 

[John C]

Nope, it's doing exactly what you are telling it do. Evaluate your formula:
Your cell highlights if the value in the cell is equal to the minimum you
specified. When F18, which is not in the range in the MIN function is equal
to the value of F16, well, the conditional formatting checks to see if the
value of F18 is equal to the MIN($F$10:$F$17,$F$19:$F$22), which it is,
therefore, the cell highlights.
When you change the value in F18, it is no longer equal to the value
generated by the MIN function.

 

[David Biddulph]

No itsn't a bug in Excel. It seems to be doing exactly what you asked it to
do. You say that in cells F10:F23 (which includes F18) you want the cell
highlighting if its value equals the minimum in the range
($F$10:$F$17,$F$19:$F$22).
You then tell us that F16 is the minimum in that range, and that F18 has the
same value. F18 therefore satisfies the conditional formatting conditions
that you have specified for that cell. Why wouldn't you expect it to impose
the format specified in that conditional formatting?
When the value in F18 no longer equals F16, and thus no longer satisfies the
specified condition, it is no longer highlighted. F16 remains the minimum
in the specified range, and thus still satisfied the condition, so it stays
highlighted. Isn't that what you asked for?