Hi Pankaj, If you want circles around the cells with values less than 30, there are two methods that come to mind.
(1) Use a data validation rule that specifies that values >= 30 are the only valid values (you can disable all warnings in the data validation rule so it will allow entry of values less than 30 without warning). Then, select the option Data Validation -> Circle Invalid Data. The circles do not update automatically, so you need to select that option each time you want to check for values <30. To clear the circles, use Data Validation>Clear Validation Circles. (2) Use VBA either in conjunction with option (1) above to update the validation circles anytie data changes, or else use VBA to draw circles on the worksheet as appropriate using drawing object (complex and I hesitate to reccomend it). If you are willing to consider indicators OTHER than circles, you have possibly even better options: (1) Use Conditional formatting to highlight the cells with values < 30. (2) In Excel 2007+ you have some sophisticated conditional formatting options that may be of interest. For example a. The rule type "Format all cells based on their values" allows you to have Excel draw in-cell data bars, use 2 or 3-color scales for values in different ranges, or use a set of in-cell colored icons. b. You could for example have a red down arrow appear in all cells whose value is less than 30 using this rule type. You can find instructions on using conditional formatting with icons at the following link: http://msdn.microsoft.com/en-us/library/office/bb407306%28v=office.11%29.asp x If you need a more detailed walk-though, or you're sure none of the listed options suffice, let me know and I'll see what I can come up with. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Secret Shot Sent: Monday, December 17, 2012 11:12 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How to creat circle on cells Dear Group, Kindly help me, i want to create Circles around the cells. means if i have some Numbers in any excel sheet and i want circle to be created on cell who have numbers less then 30. please help me. -- Pankaj Pandey Bhopal -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
