Hey everyone, I’m having trouble with a conditional formatting rule in Google Sheets. I want to highlight rows where the sum of three cells is bigger than another cell’s value. Here’s what I’ve tried:
=SUM($H2 + $I2 + $J2) > $F2
This formula is supposed to check if H+I+J is greater than F for each row. But something’s not right. The results I’m getting seem off.
Has anyone else run into this issue? Am I missing something obvious here? I’d really appreciate any tips or suggestions on how to fix this. Thanks in advance for your help!
I’ve encountered this issue before. Your formula is close, but there’s a slight adjustment needed. Try this instead:
=SUM($H2:$J2) > $F2
This simplifies the formula by using a range in the SUM function. It’s more efficient and less prone to errors.
If you’re still seeing unexpected results, double-check your data types. Ensure all cells contain numerical values. Text or blank cells can throw off the calculation.
Also, verify that the conditional formatting rule is applied to the correct range. Sometimes, the issue lies in the rule’s application rather than the formula itself.
Lastly, consider using absolute references (with $) for column letters if you plan to copy the rule across different columns. This ensures the formula adjusts correctly when applied to other areas of your sheet.
I’ve dealt with similar conditional formatting challenges in Google Sheets before. Your approach is on the right track, but there’s a small tweak needed. Instead of using SUM with addition, try this formula:
=SUM($H2:$J2) > $F2
This sums the range H2 to J2 and compares it to F2. The SUM function automatically adds the values in the specified range, so you don’t need the plus signs.
Also, make sure you’ve applied this rule to the correct range of cells. Sometimes, formatting issues occur when the rule isn’t covering all the intended rows.
If you’re still having trouble, double-check that your data types are consistent across columns. Mixed data types can sometimes cause unexpected results in comparisons.
hey there, i’ve run into this before. ur formula’s close, but try this instead:
=sum($H2:$J2) > $F2
no need for the ‘+’ signs inside SUM. also make sure ur applying it to the right cells. if it’s still wonky, check if all ur data is the same type (like all numbers). good luck!