+ Reply to Thread
Results 1 to 2 of 2

Advanced Conditional Data Validation List Help

  1. 04-18-2019, 10:34 AM #1
    frenchs88
    frenchs88 is offline
    Registered User
    Join Date
    04-18-2019
    Location
    Grand Haven, MI
    MS-Off Ver
    Version 16.24 w/ Office 265 Subscription
    Posts
    1

    Question Advanced Conditional Data Validation List Help

    Team,

    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.

    Excel Forum Help.png
    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!
    Reply With QuoteRegister To Reply
  2. 04-24-2019, 10:47 AM #2
    JeteMc
    JeteMc is online now
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,543

    Re: Advanced Conditional Data Validation List Help

    Hello frenchs88 and Welcome to Excel Forum.
    If I understand correctly then perhaps the following will help.
    First I preformatted cell M2 (sorry chose wrong cell) to fill red. I applied data validation list of a space and "1st Time" to M2. I then applied two conditional formatting rules (formulas) to M2
    Formula for red font: =M2=""
    Formula for yellow fill and font: =M2="1st Time"
    To revert the cell to red after having previously chosen '1st Time' press the Delete key.
    If this doesn't do what you want please upload a sample spreadsheet that displays your need by clicking the GO ADVANCED button below the Quick Reply window and then scrolling down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Conditional Data validation list
    By 600rob in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-20-2016, 05:32 AM
  2. conditional data validation list
    By rickdaw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-13-2012, 02:48 AM
  3. Advanced Data Validation List
    By crispybadger in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-05-2012, 02:15 PM
  4. [SOLVED] Dynamic Conditional Data Validation List
    By rackman70 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-13-2012, 11:14 AM
  5. [SOLVED] How to modify a data validation conditional list?
    By WillGe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-05-2012, 10:28 PM
  6. Filtering Data Validation List Without Using Advanced Filter
    By idlewild in forum Excel General
    Replies: 3
    Last Post: 05-15-2011, 11:46 AM
  7. Conditional Data Validation List
    By mohitspamz in forum Excel General
    Replies: 5
    Last Post: 12-08-2008, 02:52 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1