Data Validation Error in Drop Down List

snaplink22

Board Regular
Joined
Jul 6, 2018
Messages
129
Hello,

I have a drop down list that includes four cells (B13 to B16) in cell A2. One of the cells that is being used in the list is blank so users can swap back to a blank cell if they want to change their selection. The challenge I'm running in to is that when a user changes their selection back to the blank cell I get a Data Validation error. This does not impact my sheet, except I keep getting questions from the users as to why the cell has the green shaded corner edge when they do that. Do you know of a way to correct this issue?
 
Yes, when the green triangle appears, it means the cell content triggered one of the checking rules.

Which is a bit strange seeing how a blank cell is part of the drop down list and the ignore blank cells check mark is not checked. Anyway, thanks again for your help.
 
Upvote 0

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Forum statistics

Threads
1,216,028
Messages
6,128,399
Members
449,447
Latest member
M V Arun

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top