Icons

[imported_unknown]

I need to write a macro which will make a circle bigger or change colour, depending on the data number. Any ideas as to how?

 

[Fryer Tuck]

Try variations of these:

Selection.ShapeRange.ScaleWidth 1.5, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 1.5, msoFalse, msoScaleFromTopLeft
Selection.ShapeRange.Fill.ForeColor.SchemeColor = 11
Selection.ShapeRange.Fill.Visible = msoTrue
Selection.ShapeRange.Fill.Solid


You may want to do the various items while recording it as a macro.

F.T.