Forum Discussion
Conditional Formatting Formula Help
Hi everyone, i need some help on a formula in conditional formatting that has multiple criteria's. So attached is the spreadsheet ill be talking about. 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, B does not need to be highlighted. I hope this makes sense and hopefully even possible to do.
Thank you for your time and help
spalmer Try the following formula to apply conditional formatting to range C4:I4...
=AND(C$3>0,SUM(C$3:C$4)<4)Please see the attached workbook...
2 Replies
- djclementsSilver Contributor
spalmer Try the following formula to apply conditional formatting to range C4:I4...
=AND(C$3>0,SUM(C$3:C$4)<4)Please see the attached workbook...
- spalmerIron ContributorThat Seemed to do the Trick!!!! Thank you Very Much!!!!!!