Conditional formatting when cell value is top 3 of column . . .
=OR(A1=LARGE(range,{1,2,3}))
Biff
"thechilipino" wrote in message
...
hi h2000:
one possibility would to use conditional formatting - 'formula is':
=OR(A1=LARGE(range,3),A1=LARGE(range,2),A1=LARGE(r ange,1))
hth.
cheers. thechilipino.
"Hubitron2000" wrote:
Any ideas?
Thanks!
|