Home

Conditional formatting to show difference of +/- 3

%3CLINGO-SUB%20id%3D%22lingo-sub-781547%22%20slang%3D%22en-US%22%3EConditional%20formatting%20to%20show%20difference%20of%20%2B%2F-%203%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-781547%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20would%20like%20to%20highlight%20columns%20that%20contain%20cells%20with%20a%20difference%20of%20%2B%2F-%203.%3C%2FP%3E%3CP%3EFor%20example%2C%20in%20B2%3AB6%2C%20which%20contain%20various%20scores%20out%20of%2010%20points%2C%20if%20there%20were%20scores%20of%208%2C%208%2C%209%2C%20and%206%2C%20I%20want%20to%20highlight%20the%20entire%20column.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-781547%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782999%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20to%20show%20difference%20of%20%2B%2F-%203%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782999%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385008%22%20target%3D%22_blank%22%3E%40tstreet%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20very%20clear%20about%20the%20meaning%20of%20%2B%2F-%203%20difference%3C%2FP%3E%3CP%3EFrom%20the%20example%20you%20gave%2C%20I%20have%20assumed%20that%20this%20means%20that%20the%20difference%20between%20maximum%20and%20minimum.%26nbsp%3B%20If%20that%20is%20correct%20%2C%26nbsp%3B%20please%20try%20the%20following%20formula%20for%20conditional%20formatting.%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3DMAX(B%3AB)-MIN(B%3AB)%26gt%3B%3D3%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehope%20it%20works%20for%20you%20!!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-783750%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20to%20show%20difference%20of%20%2B%2F-%203%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-783750%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F368896%22%20target%3D%22_blank%22%3E%40Kodipady%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20worked%20perfectly.%20Thank%20you%20so%20much!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
tstreet
New Contributor

Hello, I would like to highlight columns that contain cells with a difference of +/- 3.

For example, in B2:B6, which contain various scores out of 10 points, if there were scores of 8, 8, 9, and 6, I want to highlight the entire column. 

 

Thank you for your help.

2 Replies

@tstreet 

I am not very clear about the meaning of +/- 3 difference

From the example you gave, I have assumed that this means that the difference between maximum and minimum.  If that is correct ,  please try the following formula for conditional formatting.    

=MAX(B:B)-MIN(B:B)>=3 

 

hope it works for you !! 

@Kodipady 

This worked perfectly. Thank you so much!

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies