Hello,
In short I wrote a code that should highlight in yellow all number matching (for example 8,000.00 and (-8,000.56)) regardless of the decimals and the positive/negative sign. For the moment the code is not complete yet but it should at least highlight the same numbers, withing column H.
The code is as follows
and this is the data in column H:
Numbers
3,064.03
2,435.51
8,037.18
(2,435.50)
599.82
(8,037.00)
10.00
100.00
In this case the code should highlight:
8,037.18
(8,037.00)
2,435.51
(2,435.50)
Thank you for your help
Bookmarks