VBA interior color criteria for columns cell

[Pinaceous]

Good Day,

In working with my sheet, I would like the cells of Column E to produce an interior color red based upon a criteria.

Criteria#1:
If and only if the cells of that row specifically cells of Columns B, C, D & F if they are populated.

Attached is an example picture of what I would like.

Do you think that you can help me create a vba code based upon this criteria?

Thank you!
Pinaceous

 

[footoo]

This is a duplicate post : VBA Red Cell Criteria

 

[bebo021999]

Sub test()
For Each cell In Range("B1", Range("B:F").SpecialCells(xlCellTypeLastCell)).Columns(4).Cells
    cell.Interior.Color = xlNone
    If IsEmpty(cell) And WorksheetFunction.CountA(Range(Cells(cell.Row, "B"), Cells(cell.Row, "F"))) = 4 Then Cells(cell.Row, "E").Interior.Color = vbYellow
Next
End Sub

 

[Pinaceous]

Yes, I created a duplicate post! I apologize! Please link or remove. Thank you!

 

[Fluff]

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

Thread closed.