Forum Discussion
aviess94
Nov 17, 2021Copper Contributor
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 ...
- Nov 17, 2021
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.
HansVogelaar
Nov 17, 2021MVP
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.
aviess94
Nov 18, 2021Copper Contributor
Thank you so much this is a huge help