Office 365 - Excel 2016: Find feature no longer highlights text

Occasional Visitor

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? 

1 Reply

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).

Related Conversations
@links .odc event tracking
Brent_Gamble in Excel on
0 Replies
Userform/Command Button to Appear in New Worksheet
Mr_Buttons in Excel on
2 Replies
Version 2001 Excel 365 and no Dynamic Arrays
MilesWilliams in Excel on
5 Replies
$ symbol changes format of cells automatically
gbetar01 in Excel on
2 Replies
Excel table formatting best practices question
Jerry1385 in Excel on
2 Replies
If/Then Formula Not Drawing Across Sheets
Matt010614 in Excel on
2 Replies