SOLVED

# Excel formula for bank rec

Occasional 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 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
7 Replies
best response confirmed by aviess94 (Occasional Contributor)
Solution

# Re: 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.

# Re: Excel formula for bank rec

Thank you so much this is a huge help

# Re: Excel formula for bank rec

Thank you.

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.

Thank you.

# Re: Excel formula for bank rec

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.

# Re: Excel formula for bank rec

Great. Thank you so much.

How can I duplicate these rules to be applied to a different range of cells?

# Re: Excel formula for bank rec

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.

# Re: Excel formula for bank rec

Thank you God bless you