Greetings everyone!
I am attempting to add a feature to a spreadsheet that I, as well as others, use for work. I believe what I want to accomplish can be achieved through conditional formatting, but to say I am experienced in this aspect of Excel, would be a lie. I will outline what I wish to accomplish below:
We have inventory levels in our business that we track on this spreadsheet. As they increase, they get closer to being unable to manage, so I'd like to automatically highlight these increases on the spreadsheet. So, for example:
If [cell x] is 500 to 1000 more than [cell y], highlight using color (let's say pink).
If [cell x] is 1001 or more than [cell y], highlight using color (let's say red).
In the above example, [cell x] would be the cell where we key in the inventory level for a particular store for a week, let's say $50,000.
[Cell Y], would be the cell that contains what the store usually trends, let's say $49,200; this is keyed in once a month at the bottom of the spreadsheet under a Budget section, where we key in the rest of our (you guessed it) budgets. Both Cell X and Y are keyed in by the user, on a weekly or monthly basis (as previously outlined).
My question is, is it even possible to create a formula that does this; and, if so, how would I go about it? Thank you very much in advance!
Bookmarks