Forum Discussion
Help with a formula, possibly and IF formula
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 ...
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