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?
 

snaplink22

Board Regular
Joined
Jul 6, 2018
Messages
129
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.
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Watch MrExcel Video

Forum statistics

Threads
1,123,380
Messages
5,601,285
Members
414,440
Latest member
Kim0204

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
Top