To remove the circle from a single cell, enter valid data in the cell. On the Data tab, in the Data Tools group, click the arrow next to Data Validation, and then click Clear Validation Circles.

Microsoft Excel: How to Remove a Drop-Down List. ... Go to the Data Validation dialog menu in the same way as if you were deleting the menu options, but instead of deleting them all, ...

How to Make Colors Change With Validation in Excel. Excel's conditional formatting tool applies formatting depending on cells' contents. Validation rules can change cells font, style, size or border.