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.