How do I get the lowest number in a row to turn red in Excel ?
You may want to use:
Formula is:
=AND(isnumber(A1),A1=MIN(1:1))
(with A1 the activecell)
Robin wrote:
Using Excel 2003. I can use the min function to find the lowest number in a
row but how do I get the lowest number in a row (or column) to change colour
so that it stands out?
Any help would be greatly appreciated.
--
Dave Peterson
|