I am working with 7 lists using conditional formatting to sort list selections by color. I am hoping to find a way to combine list results to reach a conclusion.
Each list supplies the option to choose Low, Minimal, Moderate, High. If List 1 is Moderate, List 2 is Low, and List 3 is Moderate, I'd like to show an accumulative result of Moderate. Is there a formula or rule to consider the result of each list?
Much appreciated!
Each list supplies the option to choose Low, Minimal, Moderate, High. If List 1 is Moderate, List 2 is Low, and List 3 is Moderate, I'd like to show an accumulative result of Moderate. Is there a formula or rule to consider the result of each list?
Much appreciated!
