Drop Down Dead !!!!!!!!

[williadb]

Hi Everyone,

I would like to select an option froma drop down box in excel. If i select this option then a ceratin range of cells say A1:A3 go red.

the drop down box was created by data validation. I would like the "open order: to turn the cells blue and "close order" to turn the cells blue. The cell colours depend on which option that you select from the drop down box. so say i selected open order and the cells were blue, as soon as i select closed order they turn red.

can anybody help?

Cheers
Dan

 

[Ravindra Singh]

Hi Everyone,

I would like to select an option froma drop down box in excel. If i select this option then a ceratin range of cells say A1:A3 go red.

the drop down box was created by data validation. I would like the "open order: to turn the cells blue and "close order" to turn the cells blue. The cell colours depend on which option that you select from the drop down box. so say i selected open order and the cells were blue, as soon as i select closed order they turn red.

can anybody help? Pls. help with example.

Cheers
Dan

 

[acw]

Dan

Use conditional formatting on the cell to change the color depending on the selection from the dropdown list.

In A1
Format, Conditional Format, Cell Value Is Equal to ="Open Order" then select Blue format
and
Cell value is equal to ="Close Order" then select Red format.


HTH

Tony

 

[williadb]

thx for the response Tony, i dont think this will work. i would like to basically change the colour of a row if i select a certain category from the drop down box. i think CF will only change one cell?!!?

 

[acw]

Hi

Do you want the entire row, or just a certain number of columns in the row to change???


Tony

 

[williadb]

Hi,

i would like a certain number of columns in the row to change. Thanks daniel

 

[acw]

Dan

If it is not too many columns, then apply the conditional formatting, based on the cell that contains the drop down result. How many columns are involved?


Tony

 

[williadb]

about 25 columns

 

[acw]

What version of excel are you using?


Tony

 

[williadb]

v2000

thx
dan