Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |