ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,738
- Office Version
- 2007
- Platform
- Windows
Hi,
Im using the code below.
It should work like this.
Cell G13 is a drop down where a customer is then selected.
Cell M11 is a drop down where the options to select are CAR or BIKE
Cell O14:O10 will be text shown but dependant on the above.
So all the interior colors & fonts do what should be done
BUT
My issue is when cell G13 has a customer selected & cell M11 has BIKE selected i should then see cells O14:O17 with a grey interior of which i do BUT the font colour for cell O16 is also grey where it should be Black.
See screenshot please as cell O13 shows BITING & cell O16 should say KEY TYPE but as you can see its hidden ?
In cells O13 there is the following
In cell O16 there is the following
Im using the code below.
It should work like this.
Cell G13 is a drop down where a customer is then selected.
Cell M11 is a drop down where the options to select are CAR or BIKE
Cell O14:O10 will be text shown but dependant on the above.
So all the interior colors & fonts do what should be done
BUT
My issue is when cell G13 has a customer selected & cell M11 has BIKE selected i should then see cells O14:O17 with a grey interior of which i do BUT the font colour for cell O16 is also grey where it should be Black.
See screenshot please as cell O13 shows BITING & cell O16 should say KEY TYPE but as you can see its hidden ?
In cells O13 there is the following
Rich (BB code):
=IF(M11="BIKE", "BITING", " ")
In cell O16 there is the following
Rich (BB code):
=IF(M11="BIKE", "KEY TYPE", " ")
Rich (BB code):
If Target.Address = "$M$11" Then
If Target.Count > 1 Then Exit Sub
With Range("O14,O17")
If Target.Value = "CAR" Then
.Interior.Color = 12566463
.Font.Color = 12566463
Else
.Interior.Color = 12566463
.Font.Color = vbBlack
End If
End With
End If
If Range("M11").Value = "" Then
With Range("O14:O17")
.Interior.Color = 12566463
.Font.Color = 12566463
End With
End If