ADB123
07-19-2017, 06:17 PM
Hi Guys
I use the below macro to highlight the row if the cell in column 7 is blank. I would like to do the opposite and highlight it if it is not blank.
Dim i As Long
i = Sheets(4).Range("A" & Rows.Count).End(xlUp).Row
If Replace(WorksheetFunction.Clean(Sheets(4).Cells(i, 7).Value), " ", "") = "" _
Then Sheets(4).Range(Cells(i, "A"), Cells(i, "Z")).Interior.Color = vbYellow
Any assistance will be appreciated
I use the below macro to highlight the row if the cell in column 7 is blank. I would like to do the opposite and highlight it if it is not blank.
Dim i As Long
i = Sheets(4).Range("A" & Rows.Count).End(xlUp).Row
If Replace(WorksheetFunction.Clean(Sheets(4).Cells(i, 7).Value), " ", "") = "" _
Then Sheets(4).Range(Cells(i, "A"), Cells(i, "Z")).Interior.Color = vbYellow
Any assistance will be appreciated