Home

Advanced Data Validation List Help

%3CLINGO-SUB%20id%3D%22lingo-sub-471701%22%20slang%3D%22en-US%22%3EAdvanced%20Data%20Validation%20List%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-471701%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20Team%2C%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20681px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F109477i839F8FF77D51686C%2Fimage-dimensions%2F681x192%3Fv%3D1.0%22%20width%3D%22681%22%20height%3D%22192%22%20alt%3D%22Excel%20Forum%20Help.png%22%20title%3D%22Excel%20Forum%20Help.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20above%20picture%2C%20I%20have%20a%20formula%20in%20M11%20which%20will%20fill%20the%20box%20red%20based%20in%20the%20exercise%20selected%20in%20cell%20K11.%20There%20are%20certain%20exercises%20in%20our%20library%20which%20are%20determined%20%22priority%22%20and%20must%20be%20coached%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%2C%20there%20are%20exercises%20that%20are%20not%20always%20priority%2C%20but%20only%20when%20they%20are%20new%20to%20the%20clients%2C%20thus%20I%20want%20a%20coach%20to%20be%20able%20to%20quickly%20change%20the%20cell%20to%20yellow%2C%20with%20a%20dropdown%20menu.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20cannot%20figure%20out%20a%20way%20to%20automate%20the%20cell%20to%20change%20red%20under%20some%20conditions%2C%20while%20allowing%20it%20to%20be%20manually%20changed%20to%20yellow%20without%20removing%20the%20automation%20formula%20to%20red.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughts%20on%20this%3F%20Or%20directions%20I%20should%20go%20in%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-471701%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Shawn French
Occasional Contributor

Excel Team,

Excel Forum Help.png

 

 

 

 

 

 

 

 

In the above picture, I have a formula in M11 which will fill the box red based in the exercise selected in cell K11. There are certain exercises in our library which are determined "priority" and must be coached well.

 

Then, there are exercises that are not always priority, but only when they are new to the clients, thus I want a coach to be able to quickly change the cell to yellow, with a dropdown menu.

 

I cannot figure out a way to automate the cell to change red under some conditions, while allowing it to be manually changed to yellow without removing the automation formula to red.

 

Any thoughts on this? Or directions I should go in?

 

Thank you!