Icon Sets in Conditional Formatting

[Brandon_469]

In Excel 2003, is there a way to mimic Icon Sets in Conditional Formatting
from Excel 2007?

Am I stuck with creating Macros to acheive this in Excel 2003?

 

[Norman Jones]

Hi Brandon,

To extend the Xl2003 Conditional Format
functionality, Ithink that you would require
VBA.

 

[Andy Pope]

Hi,

You can mimic some of the icon using fonts such as wingdings and then apply
normal CF to change the font colour.
So for example this formula, using WingDings font, display characters to
mimic the 4 Arrows icon set. The choice of which arrow is determined by the
value in A1.

=MID("éìîê",A1,1)

You can even mimic the rating bars by constructing shapes with transparent
areas and using CF on the cells behind the shapes.

Cheers
Andy

 

[Brandon_469]

I'm not sure I understand this application. Can you give me a more specific
example?

 

[Andy Pope]

You can use the characters displayed by the wingdings font to mimic some
of the icons used in 2007.

In A1 enter the value 1
in B1 enter the formula =MID("éìîê",A1,1)
Format B1 to have the font Wingdings. You should now see an arrow
pointing up. Change A1 to have the value 3 and the arrow should now be
pointing to bottom right.

All you have to do is use some formula to determine from your data the
value in A1. You can go a step further and add normal conditional
formatting to B1 so the font colour varys based on some logic.

I will post a page on my site, probably this weekend, on how to achieved
the more complex icons using image masks.

Cheers
Andy

 

[Andy Pope]

Here is a page explaining in more detail how to mimic the icon set.
http://www.andypope.info/tips/tip011.htm

Cheers
Andy