Re: $$Excel-Macros$$ How to creat circle on cells

2012-12-17 Thread Paul Schreiner
How are you wanting this to happen? Are you wanting to make it so that it adds the circles automatically when the cell value changes? or are you wanting to run a macro (hit a button) and have it add the circles? Keep in mind that circles would be DRAWING OBJECTS and have no actual association

RE: $$Excel-Macros$$ How to creat circle on cells

2012-12-17 Thread Asa Rossoff
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