Clip art or auto shapes

[brian5857]

In my workbook I have many cells which are condionally formated. I want to spruce up its appearance and give some of square cells the apearance of a round indicator light. I want to add a clipart or autoshape that has a trandparent circle in the middle with th area outside the circle colored white. Does anyone know if ther is a clipart or auto shape that wil give this effect?

 

[Damon Ostrander]

Hi brian5857,

There is an autoshape on the Basic Shapes submenu named "donut". It is right next to the smiley face. I believe this is what you described that you want.

Damon

 

[brian5857]

Thanks for the help. The dohnut is very similar to the autoshape I am looking for, but not exactly. Just like the dohnut, I need the inner circle to be transparent, but instead of an outer circle, I need that to be a square.

 

[Damon Ostrander]

Hi again brian5857,

I don't believe there is an autoshape that is square (rectangular?) on the outside and transparent circle on the inside. But if you want the transparent middle so that the conditional formatting area fill of the cell will show through (as a colored circle) this can be accomplished other ways. For example, rather than using conditional formatting use a filled circle in each cell (or block of cells) and use Worksheet_Change event code to change the fill color of the circle depending on a cell's value.

If you'd like to try this, but not sure how, let me know and I'll provide the code. You'll just have to provide me with the conditional formatting conditions and formatting (fill colors, etc.). For example, perhaps you want the circle to be green if a cell value is less than a certain number, yellow if greater than that number but less than a second number, and red if greater than the second number.

Damon

Damon