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