ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I draw a circle around a cell I want to highlight (https://www.excelbanter.com/new-users-excel/110392-how-do-i-draw-circle-around-cell-i-want-highlight.html)

Janev

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

Stefi

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


SteveW

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


Gord Dibben

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




All times are GMT +1. The time now is 02:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com