+ Reply to Thread
Results 1 to 2 of 2

Override Conditional Formatting Based on the Contents of Adjacent Cell

  1. #1
    Registered User
    Join Date
    06-18-2014
    Location
    Scotland
    MS-Off Ver
    2010
    Posts
    19

    Override Conditional Formatting Based on the Contents of Adjacent Cell

    Hi There,

    In reference to the attached example file I would like to have cell E5 turn green when "Done" is selected from the drop down in cell F5 but I would like the other conditional formatting to also remain in place regarding the dates and only disappear when "Done" is selected.

    Can you help?

    Example File.xlsx

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,082

    Re: Override Conditional Formatting Based on the Contents of Adjacent Cell

    Tick Stop if True in Condtional Formatting for the (F5="Done") condition
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional formatting based on cell value in an adjacent column using VBA
    By Mistweaver in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-31-2012, 06:17 PM
  2. Conditional Formatting based on Adjacent Cell
    By MacroPolo in forum Excel General
    Replies: 3
    Last Post: 06-23-2012, 01:41 AM
  3. Conditional formatting based on adjacent cell values
    By dberliner in forum Excel General
    Replies: 4
    Last Post: 07-28-2011, 12:42 PM
  4. Conditional Formatting Based on Adjacent Cell
    By Yourgurlwantsme in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-27-2010, 05:31 PM
  5. [SOLVED] How to do a conditional formatting based on an adjacent cell
    By Confused in forum Excel General
    Replies: 2
    Last Post: 01-10-2005, 06:06 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1