Conditional Formatting Icon Sets

[firstblue]

Hi,


Lately I've seen on many economic reports a set of weather icons to do conditional format, for example:

Excellent - Sunny

Fair- Cloudy

Poor - Rainy

Bleak - Storm,


Does anyone knows how to create these icon sets in excel?


Thanks

 

[Faseeh]

Hi firstblue,


Welcome to the forums, enter this formula and drag down:

=CHAR(ROW(A213))

...and drag down until Row(A219), format cell to Webdings. This will give you the pics.


Faseeh

 

[firstblue]

Hi Faseeh!


Thanks for your reply...thats really what I was looking for


Firstblue