Forum Discussion
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 turn green.
| Date | Amount | Date | Amount | ||||
| 10/01 | $4.00 | 10/01 | $7.00 | ||||
| 10/01 | $3.00 | 10/02 | $2.00 | ||||
| 10/02 | $2.00 | 10/03 | $1.00 | ||||
| 10/03 | $1.00 | 10/04 | $3.00 | ||||
| 10/04 | $1.00 |
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.
7 Replies
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.
Thank you so much this is a huge help
