Forum Discussion
conditional formatting based on percentage
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.
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.
2 Replies
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.
