Conditional Formatting Using Min/Max

[CE]

Regarding Excel 2003, I want to indicate the min value in a non-contiguous
range of cells. The data are located in cells G8, K8, O8, S8, W8, AA8 and
each cell contains a formula. So far I've tried the following formulas but
without success.
1) =MIN(G8,K8,O8,S8,W8,AA8)
2) =G8=MIN($G8,$K8,$O8,$S8,$W8,$AA8)
3) =G8=MIN($G$8,$K$8,$O$8,$S$8,$W$8,$AA$8)

Please help!

 

[T. Valko]

=G8=MIN($G8,$K8,$O8,$S8,$W8,$AA8)

=G8=MIN($G$8,$K$8,$O$8,$S$8,$W$8,$AA$8)

Those formuls are correct. Select the cells from RIGHT to LEFT then try it.

 

[Luke M]

Make sure you're using "cell value is", and "Equal to"
You can then input into the box:

=MIN(G8,K8,O8,S8,W8,AA8)

If it's still not working, perhaps check to make sure all cells in formula
contain at least 1 number (not number formatted as text) and the cell you are
formatting also contains a number.

 

[CE]

Your post gave me an idea. I substituted the G8 with AA8 and it worked! I did
it again to the next row to varify. Can you please tell me how to best copy
this to my additional 583 rows of data?

Thanks

 

[David Biddulph]

In what way was formula 1 "without success"? What values were in G8, K8,
O8, S8, W8, and AA8, and what result did the formula give in your results
cell?

Formulae 2 and 3 should return either TRUE or FALSE, depending on whether or
not G8 was the minimum.

 

[T. Valko]

When you select a *contiguous* range of cells the top left cell is the
active cell. The active cell is the one cell in the selected range that
*isn't* shaded. So the formula you enter is *relative* to the active cell.

When you select a range of non-contiguous cells the active cell is the
*last* cell of the selection and the formula will be relative to the active
cell. That's why your formula didn't work. You probably selected the cells
from left to right.

To apply this formatting to all those rows:

Select the range starting from AA8:AA583 (or whatever the last row is), then
W8:W583, S8:S583, etc, etc.

From RIGHT to LEFT so that when you're done selecting all the cells, cell G8
will be the active cell. Then use the formula:

=G8=MIN($G8,$K8,$O8,$S8,$W8,$AA8)

 

[CE]

The selected fomatting, in this case red font, did not indicate a min value.

 

[CE]

Ok folks I now have the copy issue resolved however I do have another
question. I need my formula to return results greated than 0. How exactly do
I insert this into option 2 below?

 

[T. Valko]

Change the formula to:

=AND(G8>0,G8=MIN($G8,$K8,$O8,$S8,$W8,$AA8))

 

[CE]

That works. Thanks for the assist.

Change the formula to:

=AND(G8>0,G8=MIN($G8,$K8,$O8,$S8,$W8,$AA8))

 

[T. Valko]

You're welcome. Thanks for the feedback!