goodmachine
Board Regular
- Joined
- Oct 7, 2009
- Messages
- 70
I have values in column H for a reorder point for print materials. In column O, I have the quantity on hand for said printed materials. I want to create a formula or some kind of conditional formatting that will do the following:
I'm not sure if this can be achieved, but I would love to find out. Any help is greatly appreciated.
Thank you.
- If the quantity on hand is greater than the reorder point by 50%++ (.5), the cell in column O changes to the color purple. For example, column H is 100 and column O is 200,l then cell changes to the color purple.
- If the quantity on hand is less than the reorder point by 50% (.5), the cell in column O changes to the color orange
I'm not sure if this can be achieved, but I would love to find out. Any help is greatly appreciated.
Thank you.