Forum Discussion
Conditional Formatting Help
- Dec 25, 2023
spalmer Change the rule to be based on the following formula:
=AND(C4<1,C3<>2)Done that in the attached file.
spalmer Change the rule to be based on the following formula:
=AND(C4<1,C3<>2)Done that in the attached file.
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_EekelenDec 28, 2023Platinum 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).
- spalmerDec 28, 2023Iron Contributorthank 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.