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!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies