Conditional formatting when cell value is top 3 of column . . .
 

Any ideas?

Thanks!

Conditional formatting when cell value is top 3 of column . . .
 

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!

Conditional formatting when cell value is top 3 of column . .
 

Worked great, thanks!

"thechilipino" wrote:

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!

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!