Results 1 to 7 of 7

Thread: Highlighting Cells with Conditional formatting

  1. #1
    Board Regular
    Join Date
    Mar 2019
    Posts
    63
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Highlighting Cells with Conditional formatting

    i currently have a couple of tables on a workbook. i am wanting to use some conditional formatting that will highlight certain cells when a criteria is met and will change the highlighted cells when the criteria is changed.

    i am able to highlight one cell using conditional formatting, but is there a way to highlight the other cells near it if it is highlighted?

    below is an example. so i am able to have the site highlighted, but how do i make it so it will also highlight the position and sales fields as well? so at the min i have newcastle selected in my drop down and it makes it bold. if i change the site on the drop down it changes this to bold. what i want to do is not only make the site bold but the position and sales fields bold as well. this way it makes it much easier to view the current site you are looking at.

    Position Site Sales
    1 Derby 999
    2 Newcastle 567
    3 Manchester 423
    4 Oxford 400
    5 Leicester 239

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,298
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Highlighting Cells with Conditional formatting

    Assuming "Position" is in A1 & your drop down is in F1
    Select A1 to C & last row & use this formula
    =$B2=$F$1
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    Board Regular
    Join Date
    Mar 2019
    Posts
    63
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Highlighting Cells with Conditional formatting

    Quote Originally Posted by Fluff View Post
    Assuming "Position" is in A1 & your drop down is in F1
    Select A1 to C & last row & use this formula
    =$B2=$F$1

    Hi this isnt working. it isnt highlighting any of the info now? would the B2 reference part not only highlight everything is the item in B2 matches what is in the drop down?

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,298
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Highlighting Cells with Conditional formatting

    It will highlight all 3 columns where col B matches F1 like

    Excel 2013/2016
    ABCDEF
    1PositionSiteSalesOxford
    21Derby999
    32Newcastle567
    43Manchester423
    54Oxford400
    65Leicester239

    Names



    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  5. #5
    Board Regular
    Join Date
    Mar 2019
    Posts
    63
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Highlighting Cells with Conditional formatting

    it isnt working on mine. it is just highlighting all of them when the top site matches the drop down.

    my drop down is in cell D7.
    the table i have is in J9 (headers) to L21.

    i am highlighting j10:l21 then going to conditional formatting. i am then entering =$K10=$D$7. selecting the format etc. nothing is happening. currently at the top of the table is Oxford. if i select oxford in the drop down all of the sites highlight. then if i change the site it takes the highlight off them

  6. #6
    Board Regular
    Join Date
    Mar 2019
    Posts
    63
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Highlighting Cells with Conditional formatting

    scrap that i know the issue. when i was putting the formula in i was putting =$K$10 instead of =$K10. it is working now. brilliant thanks.

  7. #7
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,298
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Highlighting Cells with Conditional formatting

    Glad it's working & thanks for the feedback.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

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
  •