VALUE WITH A CIRCLE
 

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

VALUE WITH A CIRCLE
 

What do you mean with "circle"!?

try to explain it a lil bit better, give some details!

Carlo

"teakwood" wrote:

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

VALUE WITH A CIRCLE
 

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