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.