Need help with a formula. (Excel 2003)
Need to create a conditional formula to identify spending trends.
Example:
A1= Alocated Budget, A2-A5= Spending Breakdown, A6= Total Actual Spent

If A6 is 50% or less than A1, flag "Green"
If A6 is 51% or greater than A1, flag "Red"

Thanks