In this case, it doesn't make any difference, because Excel is still able to find cells that contain only Ann.
Let's undo those changes and see what happens if we remove formatting from the Find criteria. We can now click Find Next, then click Replace. We'll use Anna for 'Replace with,' and then set a format of a blue fill, with a green border. Let's also add a format to match the orange fill we've just applied. Let's look for Ann, and select 'Match entire cell contents.'
Now let's open the Find and Replace dialog box and set up our Find options. To understand how find and replace works with formatting, let's use the name table, and the example of replacing Ann with Anna.īefore we replace any values, let's add an orange fill to all cells that contain Ann. You can even ignore values and just work with the format itself. One of Excel's really useful features is the ability to find and replace values based on formatting.
