SOLVED

Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2634381%22%20slang%3D%22en-US%22%3EConditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2634381%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20some%20trouble%20with%20conditional%20formatting.%20I%20have%20a%20data%20set%20in%20excel%20and%20I%20would%20like%202%20or%203%20conditions%20to%20apply%20to%20all%20of%20the%20respective%20points.%20These%20are%20the%20conditions%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20Alpha%20%26lt%3B%20-0.85%2C%20then%20I%20would%20like%20the%20numbers%20to%20be%20black.%3C%2FP%3E%3CP%3EIf%20Alpha%20%26gt%3B%20-0.85%20and%20Charlie%20%26gt%3B%200.1%2C%20then%20I%20would%20like%20the%20numbers%20to%20be%20blue.%3C%2FP%3E%3CP%3EIf%20Alpha%20%26gt%3B%20-0.85%20and%20Charlie%20%26lt%3B%200.1%2C%20then%20I%20would%20like%20the%20numbers%20to%20be%20red.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can%20get%20these%20conditions%20to%20apply%20to%20a%20single%20cell%20for%20each%20data%20point%2C%20but%20I%20would%20like%20to%20be%20able%20to%20apply%20them%20to%20all%20the%20points%20at%20the%20same%20time%20with%20respect%20to%20each%20other.%20It%20would%20save%20copious%20amounts%20of%20time%20to%20be%20able%20to%20apply%20them%20to%20the%20whole%20data%20set.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20could%20have%20some%20help%20that%20would%20be%20great.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2634381%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2634552%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2634552%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1125464%22%20target%3D%22_blank%22%3E%40Jonezy256%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20you%20only%20need%20two%20rules%2C%20one%20for%20blue%20and%20another%20for%20red%2C%20the%20rest%20will%20be%20black%20by%20default.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20try%20following%20formulas%20to%20make%20conditional%20formatting%20rules...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20Blue%3A%3C%2FP%3E%3CP%3E%3DAND(%24G7%26gt%3B-0.85%2C%24I7%26gt%3B0.1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20Red%3A%3C%2FP%3E%3CP%3E%3DAND(%24G7%26gt%3B-0.85%2C%24I7%26lt%3B0.1)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2641406%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2641406%22%20slang%3D%22en-US%22%3EThan%20you!%20At%20first%2C%20I%20could%20not%20tell%20if%20you%20changed%20anything%2C%20but%20I%20saw%20how%20you%20applied%20to%20to%20the%20whole%20column.%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20really%20helped%20me%20out.%3C%2FLINGO-BODY%3E
New Contributor

I am having some trouble with conditional formatting. I have a data set in excel and I would like 2 or 3 conditions to apply to all of the respective points. These are the conditions:

 

If Alpha < -0.85, then I would like the numbers to be black.

If Alpha > -0.85 and Charlie > 0.1, then I would like the numbers to be blue.

If Alpha > -0.85 and Charlie < 0.1, then I would like the numbers to be red.

 

I can get these conditions to apply to a single cell for each data point, but I would like to be able to apply them to all the points at the same time with respect to each other. It would save copious amounts of time to be able to apply them to the whole data set. 

 

If I could have some help that would be great. 

 

Thanks

3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Jonezy256 

I think you only need two rules, one for blue and another for red, the rest will be black by default.

 

You may try following formulas to make conditional formatting rules...

 

For Blue:

=AND($G7>-0.85,$I7>0.1)

 

For Red:

=AND($G7>-0.85,$I7<0.1)

 

 

Than you! At first, I could not tell if you changed anything, but I saw how you applied to to the whole column.

This really helped me out.

You're welcome @Jonezy256! Glad it worked as desired.

 

Please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.