Closed Thread
Results 1 to 2 of 2

Highlight Cell with Color during search dynamically

  1. #1
    Registered User
    Join Date
    06-01-2020
    Location
    Palm Beach Gardens, Florida
    MS-Off Ver
    Office 2016
    Posts
    1

    Highlight Cell with Color during search dynamically

    Hello Experts,

    I am looking for highlighting a cell with certain color while i am searching for certain keyword. This should happen dynamically.

    Say for example, i want to search for a keyword called 'REVOCATION' among the thousands of cells we have in a excel spreadsheet. For this i would use CTRL+F and enter keyword 'REVOCATION' and start entering ..now excel will highlight the cells which contain the word 'REVOCATION/. Here my problem is, i am not able to identify the cell, which is highlighted, because it is just white in color and borders are slightly bold. Rather, i am expecting to highlight the entire cell with RED color, so that i can easily navigate to that cell. This should happen to every excel spreadsheet, i work in my machine.

    Thanks very much for your help in advance.

    Regards,
    My Excel Tricks

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,647

    Re: Highlight Cell with Color during search dynamically

    Administrative Note:

    You will need to use your original user account. I will ask an admin to close the new one.

    Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

    Please see Forum Rule #5 about thread duplication.

    I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-gen...n-keyword.html
    Ali


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

    Forum Rules (updated August 2023): please read them here.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Find/Search and Highlight in color?
    By poppy3169 in forum Excel General
    Replies: 2
    Last Post: 03-10-2020, 05:51 AM
  2. Highlight text only (not cell) in a certain color
    By FDJ in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2020, 11:34 AM
  3. [SOLVED] Dynamically highlight the cell under the Mouse Pointer !
    By RAFAAJ2000 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-30-2019, 07:11 PM
  4. need cell to change color for only 10 min whenever it changes its value dynamically.
    By mahe1188 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2016, 01:29 AM
  5. Possible to have cell containing text highlight a certain color
    By NS4Excel in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-05-2015, 03:30 PM
  6. [SOLVED] Dynamically change cell range in formula by background color?
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2006, 05:15 PM
  7. Change a cell's fill color dynamically?
    By Arlen in forum Excel General
    Replies: 2
    Last Post: 01-22-2005, 06:06 PM

Tags for this Thread

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