Results 1 to 4 of 4

Thread: Highlighting row containing specific word in specific column

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Mar 2017
    Posts
    2
    Location

    Lightbulb Highlighting row containing specific word in specific column

    Hi!

    I am working with a project where we are using a simple excel file with data on our personell.
    I would like to create a function in the spreadsheet that highlights certain rows based on what groups the person is part of.
    I've made a small example file representing the data.

    I would like to be able to select cell E2 and that would highlight cells A2:C2 and A6:C6 because both those people are in the group "economy".
    If selecting the cell E2 is not possible as a trigger, then a macro button in G2 would suffice.

    Is there a way to create this functionality and can someone guide me in how to do this?

    Most pleased with any help you can offer!

    Best regards,
    Andreas
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

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