ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional Formatting: "handwritten" circles? (https://www.excelbanter.com/excel-discussion-misc-queries/73802-conditional-formatting-handwritten-circles.html)

UWHusky

Conditional Formatting: "handwritten" circles?
 

I am familiar with conditional formatting in Excel--however, one of the
most useful formatting options would be to create "handwritten" (i.e.
not perfectly symmetrical) circles around certain data (say, over an
amount).

I know how to set up conditional formatting, but am unaware of any
formatting option other than font or cell (background) formatting. Is
there anyway to make ellipses show up if a value meets the criteria?

Currently, I've been using the old drawing tool to draw circles around
desired values (and copying the ellipse onto subsequent desired
values). However, this takes way too long (on large worksheets)--and
furthermore, the perfectly symmetric ellipses don't provide the level
of highlighting necessary.

Please advise if there's a way to do this sort of conditional
formatting.

thanks
gt


--
UWHusky
------------------------------------------------------------------------
UWHusky's Profile: http://www.excelforum.com/member.php...o&userid=31910
View this thread: http://www.excelforum.com/showthread...hreadid=516420



All times are GMT +1. The time now is 09:56 PM.

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