+ Reply to Thread
Results 1 to 10 of 10

Using Conditional Formatting to highlight rows

  1. #1
    Registered User
    Join Date
    01-18-2016
    Location
    Lemoyne, PA
    MS-Off Ver
    2013
    Posts
    11

    Using Conditional Formatting to highlight rows

    I'm still on my list that I want employees to use. I am not good on programming so I found conditional formatting. In Column A I have a list of of keywords i.e. Roofing, Shingle, Gutters, Siding, Sheet Metal in each cell, describing what the vendor does fo us. I would like to search using the value that is input in B1 i.e. Siding. I would like it to highlight each row that it finds the word siding in. Then the user can see all of the vendors that do siding. We have a list of 400-500 vendors and I would like the to open it, type what they are looking for and be able to just go down the list to the highlighted vendors and be able to call them.

    Thanks!
    Rob
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    04-26-2020
    Location
    Massachusetts
    MS-Off Ver
    Office 365
    Posts
    93

    Re: Using Conditional Formatting to highlight rows

    For a quick and easy way to view each category just sort the file on TYPE

  3. #3
    Registered User
    Join Date
    01-18-2016
    Location
    Lemoyne, PA
    MS-Off Ver
    2013
    Posts
    11

    Re: Using Conditional Formatting to highlight rows

    TYPE doesn't have everything that they do, like Life Safety includes 20 different keywords.

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,255

    Re: Using Conditional Formatting to highlight rows

    This is similar to your other thread in which I gave a proposed solution and never received a reply.
    1. Unselect 'Show Formulas'
    2. Populate column R using: =ISNUMBER(SEARCH(B$1,A3))
    3. Use the following as a conditional formatting rule for cells B3:P43 =$R3=TRUE
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  5. #5
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B 2016
    Posts
    1,518

    Re: Using Conditional Formatting to highlight rows

    CF formula:=SEARCH($B$1,$B3) for B3:Q43

  6. #6
    Registered User
    Join Date
    01-18-2016
    Location
    Lemoyne, PA
    MS-Off Ver
    2013
    Posts
    11

    Re: Using Conditional Formatting to highlight rows

    Thank you that works!
    Rob

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    61,986

    Re: Using Conditional Formatting to highlight rows

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  8. #8
    Registered User
    Join Date
    01-18-2016
    Location
    Lemoyne, PA
    MS-Off Ver
    2013
    Posts
    11

    Re: Using Conditional Formatting to highlight rows

    I didn't know that but I do now, I gave him a star and closed the thread. Thank you!

  9. #9
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B 2016
    Posts
    1,518

    Re: Using Conditional Formatting to highlight rows

    Thanks for the Rep, Rob!

  10. #10
    Registered User
    Join Date
    01-18-2016
    Location
    Lemoyne, PA
    MS-Off Ver
    2013
    Posts
    11

    Re: Using Conditional Formatting to highlight rows

    I'm learning the tricks of the board. Thanks again!

+ 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. Replies: 6
    Last Post: 01-20-2022, 03:56 AM
  2. [SOLVED] Conditional formatting to highlight all rows - where data is the same value in a column
    By mightybracket123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-11-2021, 07:47 AM
  3. Conditional formatting to highlight both rows
    By windrain in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2020, 05:21 PM
  4. Conditional Formatting To Highlight Rows
    By melbin in forum Excel General
    Replies: 1
    Last Post: 08-14-2018, 08:41 PM
  5. Replies: 2
    Last Post: 02-14-2017, 04:00 PM
  6. Conditional formatting to highlight rows that repeat
    By bayala87 in forum Excel General
    Replies: 1
    Last Post: 09-24-2015, 01:50 PM
  7. [SOLVED] Conditional Formatting to Highlight Entire Rows
    By christopherw34 in forum Excel General
    Replies: 4
    Last Post: 05-10-2012, 04:12 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