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

Thread: More help with conditional formatting

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

    Default

    The formula +AND(A1=MIN(A:A),COUNTIF(A:A,A1)=1) works very well to find the single lowest number in a column on a worksheet without column headers. My problem is that my worksheet needs column numbers (skin game sheet for golf) 1-18 and handicap numbers for each hole. How can I get this formula to ignore row 1 & row 2?

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

    Default

    Sorry! I put + instead of = to start the formula.

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    What is in A1? This formula only returns True or False for me, not a number.
    regards
    Derek

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

    Default

    The conditional formatting looks for the single lowest number in the column. If there is one lowest, the format changes to dark grey with white font. If more than one, does nothing.

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    Sorry, I didn't realise your formula was in your conditional formatting.

    Select Column A and delete all conditional formatting.
    Select A3 and conditionally format it with the following formula (this covers the range A3:A200 - increase the 200 if you use more rows)

    =AND(A3=MIN($A$3:$A$200),COUNTIF($A$3:$A$200,A3)=1)

    Select A3:A200, select conditional formatting and click OK

    That should fix it for you
    regards
    Derek

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

    Default

    Derek,

    Thank you! This works just the way I want it to.

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
  •