Results 1 to 4 of 4

Thread: Conditional formatting to highlight duplicates with enabled/disabled drop down list
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Conditional formatting to highlight duplicates with enabled/disabled drop down list

    Hello everyone,

    I have a file with projects' staffings. Some of the workers assigned to these projects are temporary employees, some of them are permanent ones and some of them are leads. I would like to create a conditional formatting rule that highlights the permanent, associate leads and leads staff based on highlighting the duplicates so I have created three rows; one for perms, one for ALs and one for leads. The rule would stop once the drop down in the file is set to Disabled. It worked perfectly fine when I created a rule for perms, but while adding the rules for ALs and leads it started to cause problems.

    Here is an example of how I would like it to look like:


    The file highlights the regular duplicates as well, which is the most important rule in the file. It does not use any enable/disable drop down. To stop the perms+ highlighting I have used such formula:
    Code:
    =$F$3="Disabled"
    Code:
    =$F$4="Disabled"
    When adding the conditional formatting for AL's/Leads only one of the drop downs works and enables the highlighting, but it highlights all of them at once, instead of enabling only one of them.

    Can someone describe how should I do this, step by step? Macro can do as well

    Cheers,
    TLSeb

  2. #2
    New Member
    Join Date
    Jul 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: [Conditional Formatting] Using the conditional formatting to highlight duplicates with enabled/disabled drop down list

    Bump!

  3. #3
    New Member
    Join Date
    Jul 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: [Conditional Formatting] Using the conditional formatting to highlight duplicates with enabled/disabled drop down list

    I would really appreciate some help here, couldn't find a solution. Anyone?

    Bump!

    Cheers,
    Seb

  4. #4
    New Member
    Join Date
    Jul 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: [Conditional Formatting] Using the conditional formatting to highlight duplicates with enabled/disabled drop down list

    Bump! Help please!

    Cheers,
    Seb

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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