How to highlight the found cell?
1. Use WPS Office to open your spreadsheets.
2. Selecting the areas that contain the data you want to filter, click the Home tab, then select Find and Replace, you can also use the shortcut Ctrl+H.
3. Click Format before clicking pattern to set the background color as needed. Also, other format changes in Replace Formats, including Border and Font, are available to change.
4. Select Replace All to highlight the searched content.
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more.