SOLVED

# Conditional Formatting Help

Brass Contributor

# 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

6 Replies
best response confirmed by spalmer (Brass Contributor)
Solution

# Re: Conditional Formatting Help

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

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

Done that in the attached file.

# Re: Conditional Formatting Help

Thank you Very much Sir. Much appreciated. Happy Holidays

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

# Re: Conditional Formatting Help

@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

# Re: Conditional Formatting Help

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

# Re: Conditional Formatting Help

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.
1 best response

Accepted Solutions
best response confirmed by spalmer (Brass Contributor)
Solution

# Re: Conditional Formatting Help

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

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

Done that in the attached file.