Forum Discussion
Solved
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 h...
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.
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.