Can't get my conditional formatting formula to work

I am trying to apply conditional formatting on column D, It is all numbers. I would like to have the formatting apply when the a single cell in column D added up with the cell in J (in the same row) are greater that 50… example D4+J4=55… then conditional formatting applies to D4.

I am trying to use sumif but my formula skills are inadequate.

I put

=SUMIF($D1, $J1, “>=50”)

in the formula field in the condition to no avail, at least I tried… any help is appreciated.

Hello,

please try:
Formula (D1+J1)>50
Apply Style Good
Cell Range D1:D40 (as per my example, you need to adapt to your number of rows)

ConditionSumGreater.ods

Note

  • Data are random data for illustration purposes.
  • SUMIF is not the function for your use case (see Help - SUMIF)

Hope that helps.

If the answer is correct or helped you to solve your problem, please click the check mark (:heavy_check_mark:) next to the answer.

worked, thank you!!