conditional formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2409887%22%20slang%3D%22en-US%22%3Econditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2409887%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20wanting%20to%20highlight%20DV3%20one%20color%20if%20it%20is%20greater%20than%2010%25%20of%20DW3%20one%20color%20and%20a%20different%20color%20if%20it%20is%20less%20than%2010%25%20of%20DW3.%20What%20formula%20do%20I%20use%3F%20right%20now%20it%20just%20highlight%20it%20if%20it%20is%20greater%20of%20less%2C%20but%20I%20want%20to%20be%20more%20accurate%20.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2409887%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2410959%22%20slang%3D%22en-US%22%3ERe%3A%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2410959%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1069688%22%20target%3D%22_blank%22%3E%40joesanders%3C%2FA%3E%26nbsp%3BSelect%20the%20entire%20range%20you%20wish%20to%20conditionally%20format%2C%20for%20example%20DV3%3ADV100.%20Create%20the%20following%20rules%20and%20choose%20the%20colour%20you%20want.%3C%2FP%3E%3CP%3E%3DDV3%26gt%3BDW3*0.1%3C%2FP%3E%3CP%3E%3DDV3%26lt%3B%3DDW3*0.1%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMore%20detailed%20information%20on%20conditional%20formatting%20in%20the%20link%20below.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am wanting to highlight DV3 one color if it is greater than 10% of DW3 one color and a different color if it is less than 10% of DW3. What formula do I use? right now it just highlight it if it is greater of less, but I want to be more accurate .

1 Reply

@joesanders Select the entire range you wish to conditionally format, for example DV3:DV100. Create the following rules and choose the colour you want.

=DV3>DW3*0.1

=DV3<=DW3*0.1

 

More detailed information on conditional formatting in the link below.

https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60...