Hi,
I am using the below code which highlights the entire row having today's date and also dehighlights one row before.

Private Sub CommandButton1_Click()
Cells.Find(What:=Date, After:=Cells(1, 1), LookAt:=xlWhole).Activate
ActiveCell.EntireRow.Interior.ColorIndex = 6
ActiveCell(0, 1).EntireRow.Interior.ColorIndex = 2
End Sub
I am trying to modify code to include:
To highlight rows where column 'A' is populated which is a date, but any other column is in that row is not populated.

e.g. Column A to O where A is date ... A is populated and any of the columns from B to O are not populated then row gets highlighted. When all the cells ( AtoO column) in that row are populated then the row becomes dehightlighted

I did some modifications and not going anywhere. I did check other posts, but could not get it right.

Any help please

Regards