Budget Worksheet

  • Thread starter Thread starter Changing Color
  • Start date Start date
C

Changing Color

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.
 
Hi,

Select A4 and then
Format|conditional format
select
Cell value is - less than or equal to - 0
select red
Click add
Select formula is and enter this formula
=A4<$A$3*0.15
Select yellow and click OK

Mike
 
Back
Top