I am trying to make a budget worksheet that will highlight a cell a certain
color if a certain percentage of the budgeted amount is met. Currently in A1
I have the ID#, in A2 I have ID# description, in A3 I have the Budgeted
Amount and in A4 I have the formula =A3-sum(A5:A105). What I would like to
happen is when the amount in A4 reaches 15% or less than the budgeted amount
(A3) the cell will turn yellow and when A4 reaches 0 or less it will turn the
cell (A4) will turn red.