Display or hide circles around invalid data
Circle invalid cells
All cells that don't meet their data validation criteria are circled,
including values that were typed, copied, or filled in the cells, calculated
by formulas, or entered by macros.

Point to Formula Auditing on the Tools menu, and then click Show Auditing
Toolbar.
Click Circle Invalid Data .
Hide validation circles
To remove the circle from a single cell, enter valid data in the cell.
To hide all circles, point to Formula Auditing on the Tools menu, make sure
the Show Auditing Toolbar command is checked, and then click Clear Validation
Circles .

--
Regards,
Tom Ogilvy


"teakwood" wrote:

HOW TO SET A VALUE ALWAYS WITH A CIRCLE IN A CELL