Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting when inserting a row zahoulik Excel Worksheet Functions 2 January 7th 06 03:01 PM
Conditional Formatting Error ddate Excel Worksheet Functions 0 May 5th 05 09:00 PM
difficulty with conditional formatting Deb Excel Discussion (Misc queries) 0 March 23rd 05 06:13 PM
conditional formatting question Deb Excel Discussion (Misc queries) 0 March 23rd 05 02:07 AM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM


All times are GMT +1. The time now is 02:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"