방법1) 변경 전(A시트)-> 변경 후(B시트) 형식으로 표시하기

방법2) 최종 변경된 값(B시트)만 표시하기

수식보다는

vba매크로'를 사용하는 방법이 괜찮아 보입니다

 *시트명(Sheet1)과

 *범위는 변경

​

Sub Macro1()

    Dim Asht As Worksheet
    Dim lR_B&, lR_H&, bRw&, hRw As Long
    Dim rngB As Range, rngH As Range, BrngRw As Range, HrngRw As Range
    Dim Cn As Integer
    Dim isFind As Boolean

        Application.ScreenUpdating = False
        Set Asht = ThisWorkbook.Sheets("Sheet1")
        lR_B = Asht.Cells(Asht.Rows.Count, "B").End(xlUp).Row
        lR_H = Asht.Cells(Asht.Rows.Count, "H").End(xlUp).Row
        
        For hRw = 4 To lR_H
            Set rngH = Asht.Cells(hRw, "H")
            Set HrngRw = Asht.Range("I" & hRw & ":L" & hRw)
            
            isFind = False
            For bRw = 4 To lR_B
                Set rngB = Asht.Cells(bRw, "B")
                
                If rngB.Value = rngH.Value Then
                    isFind = True
                    Set BrngRw = Asht.Range("C" & bRw & ":F" & bRw)
                    
                    For Cn = 1 To 4
                        If BrngRw.Cells(1, Cn).Value <> HrngRw.Cells(1, Cn).Value Then
                            HrngRw.Cells(1, Cn).Font.Color = RGB(0, 0, 255)
                            HrngRw.Cells(1, Cn).Font.Bold = True
                        End If
                    Next Cn
                End If
            Next bRw
            
            If Not isFind Then
                HrngRw.Font.Color = RGB(0, 0, 255)
                HrngRw.Font.Bold = True
            End If
        Next hRw

End Sub

​