Conditional formatting with icon sets

[Tim]

Using Excel 2007, I would like to apply conditional formatting to a
specified block of cells using an icon set. However, I want the cells
in that block to accept only one of three values ( 1, 4, or 9 ), and
have a specific icon from an icon set be displayed instead.

I know how to apply the icon set to the block of cells, but I don't
know how to force only a 1, 4, or 9 to be entered and then display one
of the icons from a set ( stoplights where red=1, yellow=4,
green=9 ). Is this possible?

Thanks,
Tim

 

[Bob Umlas]

Use data validation to only allow the 1,4,9 and conditional formatting for
the 3 values.