Hi,
i have below data of what should be the standard minimum & maximum stock and actual available stock of the part.
i need to know how to highlight using conditional formatting the parts as conditions given below.
please help.
i have below data of what should be the standard minimum & maximum stock and actual available stock of the part.
i need to know how to highlight using conditional formatting the parts as conditions given below.
please help.
Part No | Min Stock | Max Stock | Actual Avl Stock |
A | 100 | 110 | 90 |
B | 80 | 210 | 205 |
C | 80 | 310 | 136 |
conditions for formatting | |||
Highlight "actual avl stock & Part No " in green if the "actual avl stock" is within the limit i.e. "min & Max" | |||
Highlight "actual avl stock & Part No " in Red if the "actual avl stock" is less than "min stock" | |||
Highlight "actual avl stock & Part No " in Yellow if the "actual avl stock" is more than "Max stock" |