Conditional Formatting Help

[spalmer]

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

[#2 · Accepted solution]

@spalmer Change the rule to be based on the following formula:

=AND(C4<1,C3<>2)

Done that in the attached file. 

[#3]

Thank you Very much Sir. Much appreciated. Happy Holidays

[#4]

=AND(C4<1,C3<>2)

[#5]

@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

[#6]

@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). 

[#7]

thank you so much Sir. If A=0 and B=3 or more I don't want to highlight B cause A should be highlighted and ill create something for the TOTAL to highlight if there isnt 4. thats the easy part haha.