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

 

[williadb]

columns go from b:Z. I have rows from 1 - 8. In column N is the drop down box. I would like to change the drop down to "Open". When i do this cells in this row from columns B;Z change to blue.

When i select the drop down box in the row below it, when i select "Closed" from the drop down bos i would like each cell in this row from columns b:z change to red.

I would like to be able to select any drop down box in any row so that it changes the colour of that row accordingly.

I hope this is clearer.

Thanks oNce again
Daniel

 

[acw]

Daniel

Try

Private Sub Worksheet_Calculate()
 If ActiveCell.Value = "Order Open" Then Range("B" & ActiveCell.Row & ":Z" & ActiveCell.Row).Interior.ColorIndex = 5
 If ActiveCell.Value = "Order Closed" Then Range("B" & ActiveCell.Row & ":Z" & ActiveCell.Row).Interior.ColorIndex = 3
End Sub

Tony

 

[jindon]

Hi
try this

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
With Target.Cells(1, 1)
    If Intersect(.Cells, Range("n1:n10")) Is Nothing Then Exit Sub
    Set rng = Range("b:z")
    Select Case .Value
        Case "Open"
            x = 5
        Case "Closed"
            x = 6
        Case Else
            x = 0
    End Select
    rng.Rows(.Row).Interior.ColorIndex = x
End With
End Sub