(1) Insert the function IF into the cell to be reconciled (for example, F3), enter D3 = B3 in the Logic _ Test input box of the IF Function dialog box that appears, enter Same in the Value _ IF _ True input box, and enter Value _ IF _ False? Enter "Different" in the input box and click "OK" in the unit;

(2) Set the conditional format (such as F3: F 13) in the reconciliation cell, and click the format button to set the format to red font color and yellow fill color to realize reconciliation.