#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default VALUE WITH A CIRCLE

HOW TO SET A VALUE ALWAYS WITH A CIRCLE IN A CELL
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 179
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,953
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set up a circle within a circle chart? Ken Charts and Charting in Excel 3 August 4th 06 12:39 PM
Circle on chart different in print preview Kwalityguy Charts and Charting in Excel 1 April 25th 06 09:09 PM
fill circle half way maverick3 Excel Discussion (Misc queries) 2 March 31st 06 09:21 AM
Extremely complex problem: showing a value as an 'axis' on a circle [email protected] Excel Discussion (Misc queries) 5 November 15th 05 10:57 PM
drawing/printing an exact circle talisman New Users to Excel 4 October 23rd 05 11:39 PM


All times are GMT +1. The time now is 07:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"