Change a blank cell color based on another cell value

[erutherford]

B2 has a drop down menu with two choices "50 or "55". If you select "50" I would like cell J6:J7 to turn red (no values in the cell, just a blank red cell. Every example I have seen requires a valve in my blank cell.
Thanks in advance

 

[Kaper]

Use Conditional formatting.
Select cells J6:J7 and in conditional formatting use a formula to create a formatting rule.

it can be =B2=50
or may be
=B2="50"
if you have really 50 as text (not as number) in this dropdown

 

[erutherford]

Thank you very much! Oh so close, but oh so far!
Thanks again

 

[abdelfattah]

by vba in sheet module copy and paste

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$2" Then
If Target.Value = 50 Then
Range("J1:J7").SpecialCells(xlCellTypeBlanks).Interior.Color = vbRed
End If
End If
End Sub

just write 50 in B2

 

[erutherford]

thanks, the vba might come in handy!