SOLVED
Home

conditional formatting based on percentage

%3CLINGO-SUB%20id%3D%22lingo-sub-292318%22%20slang%3D%22en-US%22%3Econditional%20formatting%20based%20on%20percentage%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-292318%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20budget%20that%20I%20am%20keeping%20track%20of%20for%20work.%20Attached%20is%20a%20picture%20of%20what%20I%20need%20to%20do.%20If%20a%20cell%20in%20the%20%22Paid%20to%20Date%22%20column%20is%20over%20the%20%22Purchase%20Order%20%24%20Issued%22%20amount%20by%205%25%2C%20I%20need%20to%20highlight%20it%20red%2C%20and%20if%20it's%20under%20by%205%25%20I%20need%20to%20highlight%20it%20green.%20Is%20there%20a%20way%20I%20can%20do%20this%3F%20Whenever%20I%20try%20to%20use%20a%20conditional%20formatting%20formula%20it%20doesn't%20work%2C%20and%20I%20don't%20want%20to%20make%20200%2B%20rules%20in%20the%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-292318%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-292709%22%20slang%3D%22en-US%22%3ERe%3A%20conditional%20formatting%20based%20on%20percentage%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-292709%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you!%20I%20don't%20know%20why%20but%20when%20I%20put%20the%20cell%20first%20instead%20of%20the%20percentage%20I%20was%20multiplying%20by%2C%20it%20wouldn't%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-292436%22%20slang%3D%22en-US%22%3ERe%3A%20conditional%20formatting%20based%20on%20percentage%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-292436%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20use%20two%20rules%20with%20formula%20for%20%22red%22%20rule%20like%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%3D%24M8%26gt%3B1.05*%24G8%3C%2FPRE%3E%0A%3CP%3Esimilar%20for%20%22green%22%20rule%20and%20apply%20them%20to%20your%20entire%20columns%20starting%20from%20row%208.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
acrowe
New Contributor

I have a budget that I am keeping track of for work. Attached is a picture of what I need to do. If a cell in the "Paid to Date" column is over the "Purchase Order $ Issued" amount by 5%, I need to highlight it red, and if it's under by 5% I need to highlight it green. Is there a way I can do this? Whenever I try to use a conditional formatting formula it doesn't work, and I don't want to make 200+ rules in the sheet.

2 Replies
Solution

Hi,

 

You may use two rules with formula for "red" rule like 

=$M8>1.05*$G8

similar for "green" rule and apply them to your entire columns starting from row 8. 

 

Thank you! I don't know why but when I put the cell first instead of the percentage I was multiplying by, it wouldn't work.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 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
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies