Conditional Formatting Using Min/Max
The selected fomatting, in this case red font, did not indicate a min value.
"David Biddulph" wrote:
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.
--
David Biddulph
"CE" wrote in message
...
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!
|