Conditional Formatting Using Min/Max

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"CE" wrote in message
...
That works. Thanks for the assist.

"T. Valko" wrote:

Change the formula to:

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

--
Biff
Microsoft Excel MVP


"CE" wrote in message
...
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?

"CE" wrote:

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!