The status column reads Open, Reopened, Open later, and Open. Rename the exact status to In progress.

Preview whole-cell matches

In a copy of the workbook, open the spreadsheet editor’s Replace dialog. Enter Open and In progress, then enable Match entire cell contents or the equivalent. Limit the search to the status range if available. Wait for the workbook to finish loading. In the sample, the matches should be rows 2 and 5.

The exact-match setting highlights Open in rows 2 and 5 only.

Illustrated match preview. Look for two whole-cell matches.

Check the values and their dependents

Replace the two matches and reread the status column. Reopened and Open later should remain. If a formula or filter tests for Open, review it separately. Save and reopen the workbook and verify the two changed rows and one unchanged row.

The status column shows In progress in rows 2 and 5 after replacement.

Illustrated saved result. Recheck any filter using the old value.

Microsoft’s worksheet Find and Replace reference