Results 1 to 7 of 7

Thread: Conditional Formatting w"ith multiple conditions

  1. #1

    Conditional Formatting w"ith multiple conditions



    Register for a FREE account, and/
    or Log in to avoid these ads!

    In the attached file:
    I want cells in "partner name" and "Balance Payment" font color to be "RED" if Activity is "Purchase" and Balance Payment is >0.
    And Font color of cells in "Partner name" and "Balance payment" to be "BLUE" if "Activity" is "Sale" and Balance Payment is >0.

    Please open the attached file "Book1.xlsx"
    If attached file ask for password, please use abdullah

    Thank you.
    Attached Files Attached Files

  2. #2
    Conjurer hossat's Avatar
    Join Date
    May 2015
    Location
    Algiers, Algeria
    Posts
    107
    Articles
    0
    Excel Version
    365
    Hi,

    I hope this solution will help you and advice you learn how to use conditional formatting with formulas.

    Book1-AHANJUM.xlsx

  3. #3
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    @hossat
    I produced a similar answer as you were doing yours, so I didn't post it.
    However, I noticed that your CF formulae reference Row 1048576 (Col C and J). The formula seems to work OK, so I was wondering if this was intentional, or another example of the many quirks and oddities of Excels Conditional Formatting?

  4. #4
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,692
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Quote Originally Posted by Hercules1946 View Post
    However, I noticed that your CF formulae reference Row 1048576 (Col C and J). The formula seems to work OK, so I was wondering if this was intentional, or another example of the many quirks and oddities of Excels Conditional Formatting?
    As the second condition uses $C2, etc I suppose hossat used the tab key inadvertently when in the CF text box ( yes one of the oddities of the CF)
    Thank you Ken for this secure forum.

  5. #5
    Thanks a lot, Hossat!

  6. #6
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    794
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by Pecoflyer View Post
    hossat used the tab key inadvertently when in the CF text box
    OIC - I hadn't realised the tab key would do that - and of course in use, the formula would simply adjust to the correct row. Thanks.

  7. #7
    Conjurer hossat's Avatar
    Join Date
    May 2015
    Location
    Algiers, Algeria
    Posts
    107
    Articles
    0
    Excel Version
    365
    @Hercules1946

    Hi,
    Sorry, I didn't read your message.
    it wasn't intentional, and I didn't noticed it
    Perhaps another weird thing of Excel

Posting Permissions

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