Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: conditional formatting problems

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I used the formula =AND(A1=MIN(A:A),COUNTIF(A:A,A1)=1)in conditional formatting to find and highlight the single lowest number in a column. This worked fine in my test sheet. When I used it in another workbook it did nothing in one column and would only highlight ones or zeroes in the others.

    "WHAT HAPPENED?"

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Funny, you should ask!!! The same thing happened to me while I was verifying a response to your posting yesterday. As a result someone else "beat me to the punch". Later, I tried it again on a fresh worksheet and it worked like a charm.

  3. #3
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Mark,

    I've been following this thread as I plan to use this in using it in a "skins" game. Do I format this before I enter scores or is there someway I can format it "after" scores are entered?

    Brian

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-08 15:55, Brian from Maui wrote:
    Mark,

    I've been following this thread as I plan to use this in using it in a "skins" game. Do I format this before I enter scores or is there someway I can format it "after" scores are entered?

    Brian
    Either way.

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Brian;
    I am developing a "skin game" sheet also. I have all the formulas for deducting strokes on the handicap side as I enter the scratch scores on the scratch side.

  6. #6
    Board Regular Brian from Maui's Avatar
    Join Date
    Feb 2002
    Posts
    8,450
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    JR

    I'm just developing one now. I have a program from GHIN, but thought of making one myself.

    Brian

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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