Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 13
Default How do I draw a circle around a cell I want to highlight

How do I draw a circle around a cell I want to highlight - I want to
see the text within the cell and colour the circle red. I tried
inserting a circle from the 'drawing toolbar' but I couldn't see the
text in the cell.

i have seen Excel worksheets with this feature and would like to
emulate it.

Thanks,

Janev
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,646
Default How do I draw a circle around a cell I want to highlight

See Tools/Formula checking/Display Formula checking Toolbar/Circle unvalid
values

Regards,
Stefi


€˛Janev€¯ ezt Ć*rta:

How do I draw a circle around a cell I want to highlight - I want to
see the text within the cell and colour the circle red. I tried
inserting a circle from the 'drawing toolbar' but I couldn't see the
text in the cell.

i have seen Excel worksheets with this feature and would like to
emulate it.

Thanks,

Janev

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 427
Default How do I draw a circle around a cell I want to highlight

Click on the circle, and change the Fill colour from automatic to *No Fill*

Steve


On Mon, 18 Sep 2006 11:03:48 +0100, Janev wrote:

How do I draw a circle around a cell I want to highlight - I want to
see the text within the cell and colour the circle red. I tried
inserting a circle from the 'drawing toolbar' but I couldn't see the
text in the cell.

i have seen Excel worksheets with this feature and would like to
emulate it.

Thanks,

Janev

  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default How do I draw a circle around a cell I want to highlight

Janev

Have a look at this google search result for a couple of methods.

http://snipurl.com/wmaw


Gord Dibben MS Excel MVP

On Mon, 18 Sep 2006 20:03:48 +1000, Janev wrote:

How do I draw a circle around a cell I want to highlight - I want to
see the text within the cell and colour the circle red. I tried
inserting a circle from the 'drawing toolbar' but I couldn't see the
text in the cell.

i have seen Excel worksheets with this feature and would like to
emulate it.

Thanks,

Janev


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
VLOOKUP - unable to highlight cell range Jane Excel Worksheet Functions 1 September 15th 06 03:34 AM
Can I highlight a cell and link it to another workbook? JennyLazz New Users to Excel 1 September 8th 06 12:07 AM
Highlight the entire row or particular cell using conditional formatting vsr_kmb New Users to Excel 1 August 20th 06 11:05 AM
insert date Larry Excel Worksheet Functions 28 July 15th 06 02:41 AM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM


All times are GMT +1. The time now is 06:11 AM.

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

About Us

"It's about Microsoft Excel"