VBA & Macro Problems

Clear an Adjacent Cell When an Excel Drop-Down Changes

Steve KSteve K Nov 18, 2026 868 views

Question details

The user wants an adjacent notification value cleared when an Excel status drop-down changes, without using VBA.

Clear an Adjacent Cell When an Excel Drop-Down Changes
Product
Microsoft Excel
Device & OS
not provided
Scenario
A table has a status drop-down and a notification field in each row.
Observed behavior
The notification should no longer appear after its row's status changes.
Before you start

Identify the status and notification columns and decide whether hiding an outdated notification is sufficient or the cell must actually be emptied. A formula can display a blank, but it cannot erase another cell or detect a past change by itself.

Solution 1Recommended

Display a blank notification with a formula

Use this no-VBA workaround when hiding an outdated notification is sufficient and you can maintain a saved status for each row.

The formula compares the current status with a manually saved status. It displays a blank when they differ, but the original notification text remains in a separate cell.

1
Set up the columns

For example, use column A for the status drop-down, column B for the displayed notification, column C for the saved status, and column D for the notification text.

2
Record the matching status

When entering a notification in D2, copy the current status from A2 into C2. Repeat this for each row that needs a notification.

3
Enter the display formula

In B2, enter =IF(A2=C2,D2,"") and fill it down the notification display column. When A2 differs from C2, B2 displays a blank.

4
Update notifications manually

When a new notification is needed, enter its text in column D and copy the current status into column C for that row.

Display a blank notification with a formula
The original text is not deleted: The notification remains in column D. If the status changes back to the saved value, the old notification will appear again. The formula cell in column B cannot also hold a manually entered notification.
Free Microsoft Office alternative

Manage Status and Notification Columns in WPS Spreadsheet

WPS Office is a free, lightweight, easy-to-use alternative with a familiar spreadsheet interface and Microsoft Office format compatibility for a smooth move between applications. You can use a formula-driven notification display, although a formula alone cannot erase another cell when a status changes.

Use formulas to display notifications based on a saved status.Open and edit Microsoft Excel formats such as XLSX.Work in a familiar spreadsheet interface.Use a free, lightweight office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Can an Excel formula clear another cell when a drop-down changes?

No. A formula can return an empty string in its own cell, but it cannot erase the contents of a different cell.

Does the formula workaround detect every status change?

No. It compares the current status with a manually saved status. If the status changes back to the saved value, the old notification appears again.

Can I type directly into the formula-driven notification cell?

Typing into the cell replaces its formula. Instead, enter the notification in a separate source cell and use the formula cell to display it.

How do I make the notification cell actually empty?

In desktop Excel, a Worksheet_Change VBA event can call ClearContents on the adjacent notification cell. Save the workbook as .xlsm and enable macros for the event to run.