How to find and replace formatted values in Excel

you might even ignore values and just work with the format itself.

Let’s take a look.

Before we replace any values, let’s add an orange fill to all cells that containAnn.

Now let’s initiate the Find and Replace dialog box and set up our Find options.

Let’s look forAnn, and select “Match entire cell contents.”

Let’s also add a format to match the orange fill we’ve just applied.

Now, let’s set up Replace options.

We can now click Find Next, then click Replace.

We can also use Replace All.

Let’s undo those changes and see what happens if we remove formatting from the Find criteria.

Now let’s adjust the Find and Replace options to work with the format only.

Let’s add the orange fill back to Find.

Then, let’s removeAnnandAnna.

Even without text to search for, Excel can still find and replace formats.

This means that you could use Find and Replace to update formats globally.

This also means you might use Find in creative ways.