Format column

[Guest]

How can I change the colour of the cells in a column depending on the
contents of one of its cells. The text in the cell is selected from a drop
down combobox.

 

[Guest]

mast,

use conditional formating, formatting/conditional formatting
select the cells you wish to apply this too, goto that menu, then enter your
criteria, and the formating you wish excel to match to that criteria

 

[Tom Ogilvy]

In xl2000 and later, this can be done with conditional formatting

See Debra Dalgleish's site

http://www.contextures.com/tiptech.html

see conditional formatting under C. There are several entries.