Jan 09 2019 09:00 AM
I am currently searching a very large file for keywords and there is only a slight outline of the row number and cell meeting my search criteria. Previously, the cell or word would be highlighted to easily identify them. I am hoping the Find feature did not permanently stop highlighting text/cell.
Is there a setting to change this?
Jan 09 2019 01:03 PM
To my knowledge there is no such setting. However, after Find All you may select all found cells in bottom frame (with Shift + arrow down or by mouse) - all of them will be highlighted. In addition, after the selection and without closing Find windows you may apply any format to all selected cells (style, or background colour, whatever).
Dec 02 2022 04:44 AM
Dec 02 2022 05:09 AM
@SergeiBaklan pointed out that the Find All button in the Find/Replace dialog can be used to highlight and - if desired - format all cells where the text is found.
By the way, this discussion is almost four years old. It's not clear to me why you felt it necessary to insult the very helpful top poster in this forum here...
Jan 13 2023 01:17 AM
Same problem here right now, excel from microsoft 365 apps fopr business, version 2211, looks like no one in the internet has really solved yet. First time i ran into this. @Office365userKD