Find And Replace Dialog Box Options. The dialog box expands to provide additional search options. Use this page of the Options dialog box to control message boxes and other aspects of a find and replace operation.
You use the Find and Replace dialog box when you want to find and optionally replace small amounts of data and when you are not comfortable using a query to find or replace data. For a replace dialog box reset all replace parameters to null set to search columns match case set options to be expanded. If a second dialog box opens select the options that you want and then select OK.
Lets say we want to highlight the new cells to remind us that we need to get in touch with the owners.
Then allow the system to run all required updates and tried it again but I am still not getting the popup box for Find Replace. To find cells with certain formatting press the Ctrl F shortcut to open the Find and Replace dialog click Options then click the Format button in the upper right corner and define your selections in Excel Find Format dialog box. Use this page of the Options dialog box to control message boxes and other aspects of a find and replace operation. Then allow the system to run all required updates and tried it again but I am still not getting the popup box for Find Replace.