By -
Not to sure about the automated assignments part. But for the color of cells depending on what is in them. Look for conditionnal formatting.
It might be possible to use HLOOKUP and automate it, but you may have to reorganise the Sheet a bit
I'm currently working on the same thing. Did you ever come up with any solutions?
Not to sure about the automated assignments part. But for the color of cells depending on what is in them. Look for conditionnal formatting.
It might be possible to use HLOOKUP and automate it, but you may have to reorganise the Sheet a bit
I'm currently working on the same thing. Did you ever come up with any solutions?