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 value
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 wi