View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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