Excel Conditional formatting of objects
 

Does anyone have a macro (or can help me create one) that will conditionally
insert an object based on values? For example, if cell A1 is between 90 and
100 insert object oval67, if the cell is between 80 and 90 insert the cell
oval68, if below 80 then insert the object oval69?

Excel Conditional formatting of objects
 

Kristina,
This may help.
http://www.contextures.com/xlCondFormat03.html#Shape

--
Cong Nguyen



"krista" wrote:

Does anyone have a macro (or can help me create one) that will conditionally
insert an object based on values? For example, if cell A1 is between 90 and
100 insert object oval67, if the cell is between 80 and 90 insert the cell
oval68, if below 80 then insert the object oval69?