Conditional formatting based on different cells

[HappyChappy]

Hi is it possible to have a range of cells a1:a50 with data in and if any of these cells are blank then a conditional format applied to cells d1:d50

so if a7 is blank then d7 would show "Holiday" in it otherwise nothing happens.

thanks in advance

 

[maabadi]

If you want formula try this at D1:

If(A1="",Holiday","")

And drag it down

If want Macro:

Sub ConditionalValue()
Dim Lr As Long, i As Long
Lr = Cells(Rows.Count, 1).End(xlUp).Row
For i = 1 To Lr
If Cells(i, 1).Value = "" Then
Cells(i, 4).Value = "Holiday"
End If
Next i

End Sub

 

[HappyChappy]

If you want formula try this at D1:

If(A1="",Holiday","")

And drag it down

If want Macro:

Sub ConditionalValue()
Dim Lr As Long, i As Long
Lr = Cells(Rows.Count, 1).End(xlUp).Row
For i = 1 To Lr
If Cells(i, 1).Value = "" Then
Cells(i, 4).Value = "Holiday"
End If
Next i

End Sub

Thank you for the help

 

[Peter_SSs]

Thank you for the help

Just for the record: If either suggestion (or both) by maabadi does what you want then your title & first post are quite misleading as neither suggestion has anything to do with conditional formatting.