Icon Sets in Conditional Formatting
 

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?

Icon Sets in Conditional Formatting
 

Hi Brandon,

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



---
Regards.
Norman


"Brandon_469" wrote in message
...
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?

Icon Sets in Conditional Formatting
 

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Brandon_469" wrote in message
...
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?

Icon Sets in Conditional Formatting
 

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

"Andy Pope" wrote:

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Brandon_469" wrote in message
...
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?

Icon Sets in Conditional Formatting
 

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

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

"Andy Pope" wrote:


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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Brandon_469" wrote in message
...

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?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Icon Sets in Conditional Formatting
 

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

Cheers
Andy

Andy Pope wrote:
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

Brandon_469 wrote:

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

"Andy Pope" wrote:


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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Brandon_469" wrote in
message ...

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?




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info