I am currently trying to use another sheet as a reference to check my main sheet which for this example would be the "working hours sheet" as my reference. For example, if the working hours for both sheets is 11, it'll check if the rows with 11 working hours in the Name sheet has one of the same code present in the Jobcode for 11 Working hours which would be LY,HR,DR . If it doesn't match it'll highlight the row in the name sheet which in this case row 6 would be highlighted
Sorry for the bad English.
Here's the code I was working on
Set n = Worksheets("Names")
Set wh = Worksheets("Working Hours")
Dim i As Long, lrow As Long
Dim v As Long
lrow = ws.Cells(Rows.Count, "A").End(xlUp).Row
For i = 1 To 100
For v = 1 To 100
If n.Cells(v, "D").Value = wh.Cells(i, "A") Then
If wh.Cells(i, "B") <> n.Cells(v, "C") Then n.Cells(i, 1).EntireRow.Interior.ColorIndex = 9
Next i
Next v
