Forum Discussion

Gae Linfoot's avatar
Gae Linfoot
Copper Contributor
Aug 22, 2018

Find and Replace function

Function is working properly however the "highlight" which turns the frame of the box into green, is too light for me to see.  I need it highlighted in such a way that it is easier to see.  I tried formatting, but of course it just affect the box I have selected.  All suggestions welcomed.  Thanks

2 Replies

  • Mr_Mitz's avatar
    Mr_Mitz
    Copper Contributor

    I wasn't able to find a way to change the "highlight" used in Excel during the Find and Replace function either.  I highly recommend that Microsoft add this Option, as the green frame around the cell is very difficult to discern at times.

     

    I did find the following work around that does what we want it to do:

     

    https://www.techwalla.com/articles/highlight-search-words-excel

     

    Try this out and let me know if it works for you.  It's working very well for me!  :-)

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor

    Did you try using the functionality like the below screenshots?