Forum Discussion
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 ...
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.
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.
Thank you.
Please see attached.
I am trying to match the amount for the correct dates. Even if the dates ate not parallel to each other.
I am also trying to make 3 of the same formals on the spreadsheet. Not sure how to copy that.
Please advise.
Thank you.
I don't know what exactly you did. but the rules for columns F to H were completely messed up. I removed them and created two new ones.