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
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: