Hi Folks,
We're using Excel 2016 on Win 10 pc's.
We use conditional formatting to change the color of a cell (to pink) if the number in it is <= to 100. That is working just fine and tells us our inventory levels are too low and we must reorder now.
What we'd like to do, however, is keep that condition in place for that cell and add another condition that "if the number(s) in A2, or A3 or A4 are >0 we then want to change the color to green.
This syntax is completely wrong but this might convey the idea:
Condition #1:
If A1<=100 Re-color this cell to Pink
Condition #2
If A2 or A3 or A4 have a number >0 Re-color A1 to Green
In practical (real world) terms, the sum in A1 represents our "Inventory In-Stock" which may be zero or any other number. If there is a number (other than 0) in A2, A3 or A4 however, those number(s) represent pending orders for more inventory. A green color in the A1 cell will tell us not to worry about our low inventory levels... we already ordered more.
So... Pink means we need to order more inventory (because there are no numbers >0 in A2, A3 or A4) and Green means we already ordered more inventory (because there are number(s) >0 in any of A2, A3 or A4.
This has kicked our butts all day long.
Any advice would be much appreciated!
Thanks Much,
Bill
We're using Excel 2016 on Win 10 pc's.
We use conditional formatting to change the color of a cell (to pink) if the number in it is <= to 100. That is working just fine and tells us our inventory levels are too low and we must reorder now.
What we'd like to do, however, is keep that condition in place for that cell and add another condition that "if the number(s) in A2, or A3 or A4 are >0 we then want to change the color to green.
This syntax is completely wrong but this might convey the idea:
Condition #1:
If A1<=100 Re-color this cell to Pink
Condition #2
If A2 or A3 or A4 have a number >0 Re-color A1 to Green
In practical (real world) terms, the sum in A1 represents our "Inventory In-Stock" which may be zero or any other number. If there is a number (other than 0) in A2, A3 or A4 however, those number(s) represent pending orders for more inventory. A green color in the A1 cell will tell us not to worry about our low inventory levels... we already ordered more.
So... Pink means we need to order more inventory (because there are no numbers >0 in A2, A3 or A4) and Green means we already ordered more inventory (because there are number(s) >0 in any of A2, A3 or A4.
This has kicked our butts all day long.
Thanks Much,
Bill