Forum Discussion

spalmer's avatar
spalmer
Iron Contributor
Dec 27, 2023
Solved

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 bu...
excel
Formulas and Functions
  • djclements's avatar
    djclements
    Dec 27, 2023

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

djclements's avatar
djclements
Silver Contributor
Dec 27, 2023

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

  • spalmer's avatar
    spalmer
    Iron Contributor
    Dec 27, 2023
    That Seemed to do the Trick!!!! Thank you Very Much!!!!!!