Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Conditional Formatting Help

Brass Contributor

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

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

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

Done that in the attached file. 

Thank you Very much Sir. Much appreciated. Happy Holidays
=AND(C4<1,C3<>2)

@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

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

Screenshot 2023-12-28 at 07.35.58.png

 

 

 

 

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

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

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

Done that in the attached file. 

View solution in original post