Thread
:
Conditional formating?
View Single Post
#
5
Don Guillett
Posts: n/a
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
Reply With Quote