Help with a formula, possibly and IF formula

Question

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.&nbsp;Probe 1&nbsp;&nbsp;Start WtTarget Wt&nbsp;&nbsp;&nbsp;28841955&nbsp;&nbsp;&nbsp;Weight%Diff&nbsp;5/26/2019264135.09&nbsp;&nbsp;5/27/2019250628.186.91Want to highlight DIFF cell with color green if cell is less than 10 and red if greater than 10.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;For example:&nbsp; 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.&nbsp; If greater than 10, then I want the cell to be red so that it stands out.

sergeibaklan · Answer

Deleted&nbsp;, 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)&lt;=10)*(LEN($D5)&gt;0)      for the green
=(ABS($D5)&gt;10)                    for the red

Forum Discussion

Help with a formula, possibly and IF formula

1 Reply

	Probe 1
	Start Wt	Target Wt
	2884	1955
	Weight	%	Diff
5/26/2019	2641	35.09
5/27/2019	2506	28.18	6.91	Want 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.