Conditional formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2610935%22%20slang%3D%22en-US%22%3EConditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2610935%22%20slang%3D%22en-US%22%3E%3CP%3EI%20know%20how%20to%20use%20conditional%20formatting%20to%20highlight%20a%20specific%20value%20in%20a%20column%20Ex%3A%26nbsp%3B%20all%20instances%20of%204%20in%20column%20D%20will%20be%20purple%2C%20but%20how%20do%20I%20use%20%2F%20is%20there%20a%20way%20to%20apply%20conditional%20formatting%20to%20highlight%20multiple%20specific%20numbers%20%2C%20ex%3A%207.18%2C%2012.45%2C%208.69%20in%20green%2C%26nbsp%3B%206.84%2C%2014.22%2C%2021.65%20in%20orange%2C%20so%20as%20not%20to%20have%20in%20this%20example%206%20rules%20but%20only%202.%26nbsp%3B%20%26nbsp%3BHopefully%20this%20makes%20sense.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2610935%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-2611044%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2611044%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1120457%22%20target%3D%22_blank%22%3E%40Stephen2532%3C%2FA%3E%26nbsp%3BSelect%20column%20D%20and%20create%20a%20formatting%20rule%20using%20a%20formula%20like%3A%3C%2FP%3E%3CP%3E%3DOR(D1%3D6.84%2CD1%3D14.22%2CD1%3D21.65)%20and%20apply%20it%20to%20the%20entire%20D%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I know how to use conditional formatting to highlight a specific value in a column Ex:  all instances of 4 in column D will be purple, but how do I use / is there a way to apply conditional formatting to highlight multiple specific numbers , ex: 7.18, 12.45, 8.69 in green,  6.84, 14.22, 21.65 in orange, so as not to have in this example 6 rules but only 2.   Hopefully this makes sense.

1 Reply

@Stephen2532 Select column D and create a formatting rule using a formula like:

=OR(D1=6.84,D1=14.22,D1=21.65) and apply it to the entire D column.