Forum Discussion

aviess94's avatar
aviess94
Copper Contributor
Nov 17, 2021
Solved

Excel formula for bank rec

Hi ,   I am trying to match 2 columns against 2 columns. I want the columns to turn red if they dont match and green if they do. As long as the dates have the same sum on money I want them to both ...
  • HansVogelaar's avatar
    Nov 17, 2021

    aviess94 

    See the attached sample workbook. Click in A2 or D2 and select Conditional Formatting > Manage Rules... to see the definition of the rules that I created.

Resources