Conditional Formatting Icons

**hlb129** · 04-04-2012, 02:25 PM

I am creating a large matrix (Excel 2010) and would like to use the Quarters Icon sets, but I do not want black/white icons. I would like to use red, yellow, and green, to display the level of expertise by employee. I read that I can import the icon or is there another method to change the Quarter to a color icon?

**dilipandey** · 04-04-2012, 02:44 PM

Hi hld129,

Welcome to the forum.

what type of icon you are looking for.. are they fonts - customized or formatted or some objects (inset - > objects )?

Regards,
DILIPandey

<click on below 'star' if this helps>

**hlb129** · 04-11-2012, 08:14 AM

I am looking for the "Quarter" conditional formatting icons. Black & White icon sets are in the Excel program, but I am looking to either change the icon to color (red, yellow, green) or import the color icon set.

**dilipandey** · 04-11-2012, 08:30 AM

Hi hlb129,

Would suggest you to post a sample workbook containing those icon sets .. thanks

Regards,
DILIPandey

<click on below 'star' if this helps>

**hlb129** · 04-11-2012, 08:50 AM

Please see attachment.

**JosephP** · 04-11-2012, 09:02 AM

You can't add your own icons you can only use icons from other sets in the default sets or change the order of the icons.

**hlb129** · 04-11-2012, 09:24 AM

I was told that for Excel 2007, but I heard that it was possible to import, or change, with Excel 2010.

**JosephP** · 04-11-2012, 09:27 AM

'fraid not, at least as far as I know. You can use icons from different sets together but not bring in your own. If you can, microsoft don't seem to mention it anywhere and that would surprise me.