How can you display a message when a cell value exceeds 75 % of the allowed expenditure.
Let us say the Cell in D6 is the Maximum allowed and the Cell D5 is the Rolled up total of expenditure.
e.g.: If D6 is $100,000 then, when D5 exceeds $75,000 then either make the cell blink or display a message saying: "You have reached the 75% of the allowed expenditure and therefore requires your attention!"
I frankly could not figure out a way to do that and your help will be much appreciated.
Thanks in advance!
Bookmarks