Forum Discussion
Excel formula for bank rec
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.
- Great. Thank you so much.
How can I duplicate these rules to be applied to a different range of cells?- Thank you God bless you
Select a cell with conditional formatting.
On the Home tab of the ribbon, click Conditional Formatting > Manage Rules...
Select one of the rules and click Edit Rule...
Press Tab once to select the formula box.
Press Ctrl+C to copy the formula.
For ease of use, I'd either paste the formula into an empty cell, or into for example Notepad.
Inspect the formula carefully, then modify it for use in another range.