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
Bookmarks