How do I draw a circle around a cell I want to highlight

[Janev]

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

 

[Stefi]

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

Regards,
Stefi


„Janev†ezt írta:

 

[SteveW]

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

Steve

 

[Gord Dibben]

Janev

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

http://snipurl.com/wmaw


Gord Dibben MS Excel MVP