+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Hubitron2000
    Guest

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

    Any ideas?

    Thanks!

  2. #2
    thechilipino
    Guest

    RE: 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(range,1))

    hth.

    cheers. thechilipino.

    "Hubitron2000" wrote:

    > Any ideas?
    >
    > Thanks!


  3. #3
    Hubitron2000
    Guest

    RE: 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(range,1))
    >
    > hth.
    >
    > cheers. thechilipino.
    >
    > "Hubitron2000" wrote:
    >
    > > Any ideas?
    > >
    > > Thanks!


  4. #4
    Biff
    Guest

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

    =OR(A1=LARGE(range,{1,2,3}))

    Biff

    "thechilipino" <thechilipino@discussions.microsoft.com> wrote in message
    news:97B2EEC6-947F-491D-9910-E857CFF3FBF4@microsoft.com...
    > 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!




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1