How do I get the lowest number in a row to turn red in Excel ?
Select your rows to format.
(Say A1 is the activecell)
Format|conditional formatting
cell Value is
equal to
=Min(1:1)
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
|