Results 1 to 10 of 10
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Conditional Format

    Hi I am trying to format a simple column of say 1 to 10 when I try to conditional format the highest number I use Max so that no 10 changes to red, but no matter what i try the whole column turns red.

    I am in my dotage but it thought this would be simple.

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Can you post the formula you are using ?
    My guess is that you have some unwanted $ signs but is is only a guess.

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,634
    Thanks
    115
    Thanked 649 Times in 592 Posts
    Braddy,

    amend your formula to:

    =A1=MAX($A$1:$A$10)

    CF.png

    HTH,
    Maud

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post
    Hi MatinM

    Thanks for the reply but Maudibe worked for me
    Braddy
    If you are a fool at forty, you will always be a fool

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post
    Hi Maudibe

    Thanks for that, I don't want to impose but is there a way to show the lowest and the highest in the same column
    If you are a fool at forty, you will always be a fool

  6. #6
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,634
    Thanks
    115
    Thanked 649 Times in 592 Posts
    Np,
    Create a second rule and use the min formula

  7. #7
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    If your column range could contain blanks or text, then MINA(range) might be a better function to find the smallest numeric value.
    Last edited by MartinM; 2015-07-15 at 12:07.

  8. #8
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,634
    Thanks
    115
    Thanked 649 Times in 592 Posts
    Good thought Martin but I don't think the MIN function would be affected by blanks or text where MINA function is. Apologies if I am wrong.

    Maud

  9. #9
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post
    Thanks to all who replied

    Braddy
    If you are a fool at forty, you will always be a fool

  10. #10
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    No apologies needed Maud - I was wrong !

Posting Permissions

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