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 ? (Excel 2003)

    Hi

    I am having a problem with conditiional formatting.

    Please see attached

    Many Thanks

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

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Format ? (Excel 2003)

    "Halfway between List and MSRP" would be (List+MSRP)/2, for example in row 7: (M7+N7)/2
    Does that help?

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

    Re: Conditional Format ? (Excel 2003)

    Hi Hans

    Thanks for the prompt reply, but as usual I haven't expressed myself properly, what I should have stated is any figure halfway between MRSP and List. Need approval

    Sorry for that.

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

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Format ? (Excel 2003)

    What do you mean by "halfway"? Do you simply mean "any figure between MRSP and List"?

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

    Re: Conditional Format ? (Excel 2003)

    Hi Hans

    Yes any figure any figure not greater than halfway between MRSP and List

    Please see attached I give a better explaination.

    Thanks

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

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Format ? (Excel 2003)

    Your explanation is still very confusing. In your examples you seem to use "half of MSRP", but you keep on mentioning "halfway between List and MSRP".

    For example, in row 7:
    List = 20
    MSRP = 52.97
    The limit you mention is 26.48, this is half of MSRP.
    but halfway between List and MSRP would be (20+52.97) / 2 = 36.48

    And the 24.77 you mention at the end is completely incomprehensible.

    Please explain in a plain and coherent manner what you want.

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

    Re: Conditional Format ? (Excel 2003)

    Hi Hans

    I made a typo in the file attached last time.

    Corrected workbook attached.

    Thanks

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

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Format ? (Excel 2003)

    Try this formula in O7:

    =IF(ISBLANK(P7),"",IF(P7<N7,"No",IF(P7<(M7+N7)/2,"Needs Approval","OK")))

    and fill down to O9.

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

    Re: Conditional Format ? (Excel 2003)

    Hi Hans

    Please see attached does this explain it better
    If you are a fool at forty, you will always be a fool

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

    Re: Conditional Format ? (Excel 2003)

    Hi Hans

    Thats works just fine, once again I am sorry to try your patience.

    Grateful thanks

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

Posting Permissions

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