Hey Guys/Gals,
Example:
5 7 <--- This one would not turn a color since it didn't drop below 5
6 4 <--This one would turn red meaning that I need to reorder more
From the example above, I want to reference the number right next to it and when the number drop below the first column (Cell next to it) it will turn red. Any idea's on a formula that could do this.
Thank you for your help.
Example:
5 7 <--- This one would not turn a color since it didn't drop below 5
6 4 <--This one would turn red meaning that I need to reorder more
From the example above, I want to reference the number right next to it and when the number drop below the first column (Cell next to it) it will turn red. Any idea's on a formula that could do this.
Thank you for your help.
