Forum Discussion

spalmer's avatar
spalmer
Iron Contributor
Dec 25, 2023
Solved

Conditional Formatting Help

Hi everyone, need some help with conditional format using a formula I'm assuming. In the attached sheet, I have a row that is highlighted in blue because there are 0 of them. What I'm looking for is, if there are 2 "A's" (in Red) above I don’t want that cell highlighted in blue. So E4 and F4 I don't want highlighted but would still want the others highlighted in blue because there are 0..  Thank you for all Help

    • spalmer's avatar
      spalmer
      Iron Contributor

      Riny_van_Eekelen , abdelazizallam so what if I have multiple criteria's.  So attached is the same spreadsheet.  Between the A's and B's, I need at least 4 but a minimum of 1 "A".  so if there is 1 "A" but 2 or less "B's" I want the B to highlight blue, if there are 4 "A's", "B" does not need to be highlighted. if there are 2 A's and 2 B's that also does not need to be highlighted.  I hope this makes sense and hopefully even possible to do.

       

      Thank you again for your time and help

      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor

        spalmer I've added a few rules and some extra information that should help you understand better why and how the CF rules work.

         

        Note that there is one discrepancy in comparison to your file. What to do with B if A = 0 and the total is not 4 ? The rules that you mentioned will highlight B (white on blue). 

         

         

         

         

    • spalmer's avatar
      spalmer
      Iron Contributor
      Thank you Very much Sir. Much appreciated. Happy Holidays

Resources