View Single Post
  #5   Report Post  
Don Guillett
 
Posts: n/a
Default

try it like this
=a1=min($d$1:$f$10,$h$1:$i$10)
--
Don Guillett
SalesAid Software

"dbrumit" wrote in message
...
I originally stated that I wanted the highest value, but it is the lowest
value that I need, so I changed max to min and that worked. I now need to
apply this to the whole column. I actually need columns D E F H

If we cant skip column G, I can have them all run together.

Thank you very much for your help!

Dan


"Don Guillett" wrote:

try formula is
=a1=max($a$1:$c$1)

--
Don Guillett
SalesAid Software

"dbrumit" wrote in message
...
I would like the the font of the highest value of 3 cells. A1,B1,C1 to

be
large.

Thanks