Automatic Subtraction Of Column Values To Adjacent Column

[sanjeevi888]

Dear Experts,

i want Auto Subtraction between A1:A1000 - B1:B1000 Value apply to C1:C1000 in conditional formatting.
find attachment.

Regards,

Sanjeevi.

[Excel Fox]

Can you elaborate that please? Are you saying you want to automatically have the column C have the difference of the values in columns A and B?

[sanjeevi888]

Yes that one..!

[Excel Fox]

Try this....

Paste this in the sheet code module

Private Sub Worksheet_Change(ByVal Target As Range)

    If Target.Cells(1).Column <= 2 Then
        With Me
            .Range("C2:C" & Application.Max(2, Me.Cells(Rows.Count, 3).End(xlUp).Row)).ClearContents
            .Range("C2:C" & Application.Max(.Cells(Rows.Count,  1).End(xlUp).Row, .Cells(Rows.Count, 3).End(xlUp).Row)).Formula =  "=A2-B2"
        End With
    End If
        
End Sub