Conditional Formatting Assistance...

[dougcash35]

I am trying to assist someone with reconciling all of their business financial information into one excel workbook. It has become a little complicated now that I have worksheets for bank information, time keeping information, and multiple quick book exports. I have noticed that the check numbers in the bank information are not matching all the time with the check numbers that were entered into quick books.

Is there a formula I can use to make the check numbers on the bank information sheets turn green if they are on the quick books sheet, and turn red if they are not?

Bank Information Sheet
​

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Check No (Column A)
[/TD]
[TD](Column B)
[/TD]
[/TR]
[TR]
[TD](Row 1) 1
[/TD]
[TD]100.00
[/TD]
[/TR]
[TR]
[TD](Row 2) 2
[/TD]
[TD]200.00
[/TD]
[/TR]
</tbody>[/TABLE]

Checks from Quick Books
​

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Check No (Column A)
[/TD]
[TD](Column B)
[/TD]
[/TR]
[TR]
[TD](Row 1) 1
[/TD]
[TD]100.00
[/TD]
[/TR]
[TR]
[TD](Row 2) 3
[/TD]
[TD]300.00
[/TD]
[/TR]
</tbody>[/TABLE]

I would really love it if I could just see at a glance which checks are not accounted for!

Thanks!!

 

[dougcash35]

perfect, thanks!!