+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting

  1. #1
    Registered User
    Join Date
    01-16-2023
    Location
    Reading, England
    MS-Off Ver
    365
    Posts
    2

    Conditional Formatting

    Hi All,

    I am aware this may not be possible but hoping the hive mind can assist.

    I am trying to have specific cells highlight whenever a code on the left ranging from TW1 through to TW7 is selected. The appropriate cells then need to highlight to remind the employee to do the actions listed above them.

    I am able to get the specific cell featuring the text to highlight, but is there a way to have cells I,J & K also highlight? TIA

    Code sheet.xlsx

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,639

    Re: Conditional Formatting

    Welcome to the Forum James TW!


    The file you have attached has no conditional formatting so it is hard to figure out what you are trying to extend to columns I, J, and K.

    I am trying to have specific cells highlight
    what are the specific cells?
    whenever a code on the left ranging from TW1 through to TW7 is selected
    How does the code from TW1 to TW7 determine the highlighting?
    The appropriate cells then need to highlight
    What are "the appropriate cells"?
    I am able to get the specific cell featuring the text to highlight
    What is the specific cell? As I said, there is no conditional formatting in this file.
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    01-16-2023
    Location
    Reading, England
    MS-Off Ver
    365
    Posts
    2

    Re: Conditional Formatting

    Hi Jeff,

    The work book is my reference page.

    What I am trying to achieve is that when the code

    TW1 is selected in G that I, J & K highlight.
    TW2 is selected in G that I through to Q highlight

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,639

    Re: Conditional Formatting

    There is no pattern so which cells get which color for which value in column G, so you have to write individual rules for each color, each column, each value that G can have. That is very long, tedious, and difficult to maintain.

    I have created a Key table based on what you have provided that makes this all table-driven with one rule for each color.

    I have also created sheet Solution for Testing. It populates the cells based on what you select from the dropdown in column G. Please let me know if this is what you had in mind.

    To Test:

    Open sheet Solution for Testing. Use the dropdown lists in column G to select any value. The values and colors in the table to the right will be automatically updated to match Key.
    Attached Files Attached Files

+ 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. [SOLVED] Conditional Formatting based on another cells Conditional Formatting
    By chriskay in forum Excel General
    Replies: 4
    Last Post: 08-22-2019, 05:33 AM
  2. [SOLVED] Override conditional formatting (in general, without changing the conditional formatting)
    By Stormin' in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2017, 07:15 AM
  3. Conditional Formatting Removing Previous Conditional Formatting?
    By CravingGod in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2016, 01:02 PM
  4. Replies: 6
    Last Post: 01-08-2016, 06:44 PM
  5. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  6. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  7. Replies: 3
    Last Post: 05-15-2012, 04:13 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