May 27 2019 03:18 PM
May 27 2019 03:18 PM
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 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. |
May 27 2019 03:30 PM
@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