Format column
 

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.

Format column
 

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

"mast" wrote:

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.

Format column
 

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.

--
Regards,
Tom Ogilvy


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