Drop Down Options

[Jenngv]

Can I carry fill and font color to a cell from drop down data?
For example; if I choose "A", the fill color of that cell will be red with
an A.
or
If I choose "B", the font color of the B is blue.
Thanks!

 

[FSt1]

hi
assuming that you are talking about data validation...yes. but you would
need to use conditional formating with it. or some heavy duty sheet code.
with conditional formating you are limited to 3 conditions in 2003 and
earlier.
in 2007, you are limited by system resorces i.e. how much memory do you have.

if you talking about a combo box, yes again but requires code and a tad bit
more details on your part.

regards
FSt1

 

[Jenngv]

I have 2007....

hi
assuming that you are talking about data validation...yes. but you would
need to use conditional formating with it. or some heavy duty sheet code.
with conditional formating you are limited to 3 conditions in 2003 and
earlier.
in 2007, you are limited by system resorces i.e. how much memory do you have.

if you talking about a combo box, yes again but requires code and a tad bit
more details on your part.

regards
FSt1