Pratap 1987
08-12-2016, 05:33 AM
Hi there,
Could one of you please help me in building a macro for the below requirement.
Basically, I am trying to compare the Dates and Amounts in 2 different columns and highlight exceptions:
I have a spreadsheet - Where Col K & V have Dates on it - And Col N & Z has amounts on it.
Need a macro to look for the Dates from Col K to V and if match found - Compare the amounts from Col N to Z.
Any mismatch in amounts greater than 0.99 or any amounts which does not have a match should be highlighted in Red.
Points to note:
Amounts in Col N & Z - Could be in + or - sign - So the amounts are compared - It should look for opposite signs.
Mismatch should be highlighted in both ways - ie, Mismatches in Col N and Col Z has to be highlighted (not just 1 Col).
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
1
Date
Db (They)
Date
Cr (We)
2
1-Jul-16
-100.00
2-Jul-16
3
1-Jul-16
2-Jul-16
4
2-Jul-16
5-Jul-16
700.00
5
2-Jul-16
6-Jul-16
6
4-Jul-16
-350.00
4-Jul-16
7
4-Jul-16
4-Jul-16
350.00
8
5-Jul-16
-700.00
1-Jul-16
100.00
9
6-Jul-16
-111.00
1-Jul-16
Could one of you please help me in building a macro for the below requirement.
Basically, I am trying to compare the Dates and Amounts in 2 different columns and highlight exceptions:
I have a spreadsheet - Where Col K & V have Dates on it - And Col N & Z has amounts on it.
Need a macro to look for the Dates from Col K to V and if match found - Compare the amounts from Col N to Z.
Any mismatch in amounts greater than 0.99 or any amounts which does not have a match should be highlighted in Red.
Points to note:
Amounts in Col N & Z - Could be in + or - sign - So the amounts are compared - It should look for opposite signs.
Mismatch should be highlighted in both ways - ie, Mismatches in Col N and Col Z has to be highlighted (not just 1 Col).
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
1
Date
Db (They)
Date
Cr (We)
2
1-Jul-16
-100.00
2-Jul-16
3
1-Jul-16
2-Jul-16
4
2-Jul-16
5-Jul-16
700.00
5
2-Jul-16
6-Jul-16
6
4-Jul-16
-350.00
4-Jul-16
7
4-Jul-16
4-Jul-16
350.00
8
5-Jul-16
-700.00
1-Jul-16
100.00
9
6-Jul-16
-111.00
1-Jul-16