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.