Conditional Formatting Using Min/Max
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.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"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!
|