Any ideas?
Thanks!
Any ideas?
Thanks!
hi h2000:
one possibility would to use conditional formatting -> 'formula is':
=OR(A1=LARGE(range,3),A1=LARGE(range,2),A1=LARGE(range,1))
hth.
cheers. thechilipino.
"Hubitron2000" wrote:
> Any ideas?
>
> Thanks!
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(range,1))
>
> hth.
>
> cheers. thechilipino.
>
> "Hubitron2000" wrote:
>
> > Any ideas?
> >
> > Thanks!
=OR(A1=LARGE(range,{1,2,3}))
Biff
"thechilipino" <[email protected]> wrote in message
news:[email protected]...
> hi h2000:
>
> one possibility would to use conditional formatting -> 'formula is':
>
> =OR(A1=LARGE(range,3),A1=LARGE(range,2),A1=LARGE(range,1))
>
> hth.
>
> cheers. thechilipino.
>
> "Hubitron2000" wrote:
>
>> Any ideas?
>>
>> Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks