Help with a formula, possibly and IF formula

Deleted
Not applicable

I want Excel to make a cell the color red if two cells subtracted from each other is greater than 10 and green if said two cells are less than 10.

 Probe 1 
 Start WtTarget Wt  
 28841955  
 Weight%Diff 
5/26/2019264135.09  
5/27/2019250628.186.91Want to highlight DIFF cell with color green if cell is less than 10 and red if greater than 10. 
    For example:  If the difference between the cell with 35.09 and the cell with 28.18 is less than 10, then I want the cell with the total (6.91 in sample) to show green.  If greater than 10, then I want the cell to be red so that it stands out.
1 Reply

@Deleted , if, for example, you Diff range starts from the cell D5, you may apply conditional formatting rule s (one for each color) to your range (e.g. D5:D1000) with the formulas like

=(ABS($D5)<=10)*(LEN($D5)>0)      for the green
=(ABS($D5)>10)                    for the red