You are reading a single comment by @Light_EDDed and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Light_EDDed
I don't do budgets, who knew, but I'm a bit confused by what you're after here as it's not all in one place.
You have a total amount to be spent.
You have a cumulative amount spent so far.
You want to know when that cumulative is within 25%,50%, and 75% of the total?
If you have the annual budget in
E6
the weekly spend (which I'm hoping is fed into this sheet from another place and not manually entered) in
F6
then do the percentage of f6/e6
then in h6 write this
=IF(G6<=0.25,1,IF(AND(G6 >=0.25, G6<=0.49),2,IF(AND(G6 >=0.49, G6<=0.74),3,IF(G6>=0.75,4,0))))
then if you apply conditional formatting to h6, you can apply icon sets with a four icon set so that
4 red flag
3 amber flag
2 green flag
<2 no icon
then hide the number when you edit the conditional rule. and you're jsut left with an icon next to the number.