Home

Help with a formula, possibly and IF formula

%3CLINGO-SUB%20id%3D%22lingo-sub-650882%22%20slang%3D%22en-US%22%3EHelp%20with%20a%20formula%2C%20possibly%20and%20IF%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-650882%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20Excel%20to%20make%20a%20cell%20the%20color%20red%20if%20two%20cells%20subtracted%20from%20each%20other%20is%20greater%20than%2010%20and%20green%20if%20said%20two%20cells%20are%20less%20than%2010.%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EProbe%201%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EStart%20Wt%3C%2FTD%3E%3CTD%3ETarget%20Wt%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E2884%3C%2FTD%3E%3CTD%3E1955%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EWeight%3C%2FTD%3E%3CTD%3E%25%3C%2FTD%3E%3CTD%3EDiff%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F26%2F2019%3C%2FTD%3E%3CTD%3E2641%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E35.09%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E5%2F27%2F2019%3C%2FTD%3E%3CTD%3E2506%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E28.18%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3E%3CSTRONG%3E6.91%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%3EWant%20to%20highlight%20DIFF%20cell%20with%20color%20green%20if%20cell%20is%20less%20than%2010%20and%20red%20if%20greater%20than%2010.%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3EFor%20example%3A%26nbsp%3B%20If%20the%20difference%20between%20the%20cell%20with%2035.09%20and%20the%20cell%20with%2028.18%20is%20less%20than%2010%2C%20then%20I%20want%20the%20cell%20with%20the%20total%20(6.91%20in%20sample)%20to%20show%20green.%26nbsp%3B%20If%20greater%20than%2010%2C%20then%20I%20want%20the%20cell%20to%20be%20red%20so%20that%20it%20stands%20out.%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-650882%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-650904%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20a%20formula%2C%20possibly%20and%20IF%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-650904%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F349681%22%20target%3D%22_blank%22%3E%40Jesscl%3C%2FA%3E%26nbsp%3B%2C%20if%2C%20for%20example%2C%20you%20Diff%20range%20starts%20from%20the%20cell%20D5%2C%20you%20may%20apply%20conditional%20formatting%20rule%20s%20(one%20for%20each%20color)%20to%20your%20range%20(e.g.%20D5%3AD1000)%20with%20the%20formulas%20like%3C%2FP%3E%0A%3CPRE%3E%3D(ABS(%24D5)%26lt%3B%3D10)*(LEN(%24D5)%26gt%3B0)%20%20%20%20%20%20for%20the%20green%0A%3D(ABS(%24D5)%26gt%3B10)%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20for%20the%20red%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
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
Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies