Clear an Adjacent Cell When an Excel Drop-Down Changes
Question details
The user wants an adjacent notification value cleared when an Excel status drop-down changes, without using VBA.

- 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.
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.
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.
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.
When entering a notification in D2, copy the current status from A2 into C2. Repeat this for each row that needs a notification.
In B2, enter =IF(A2=C2,D2,"") and fill it down the notification display column. When A2 differs from C2, B2 displays a blank.
When a new notification is needed, enter its text in column D and copy the current status into column C for that row.

Clear the notification cell with a worksheet change event
Use this optional VBA approach if the notification cell must actually be emptied when the status changes.
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.

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.




