View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
UWHusky
 
Posts: n/a
Default 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