conditional formatting based on percentage

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



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


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.