Color Table B for the same Criteria

[Rajkumar_h]

Hello,

I require help in building a macro for the attached example.

Example1.PNG

We have two identical tables sitting in the same sheet (table A and B). Table A is formulated and when ever any numbers gets captured, in Table B for the same criteria the cell needs to get colored. I had written the below code but i not finding a way to complete it. Please could someone help me on this to complete it.

Please Login or Register  to view this content.

Many thanks in Advance!
Rajkumar

[kev_]

You can colour the cells without VBA
- use conditional formatting
- select the range, starting at N2 and use this formua in conditional formatting
- see attached file

Please Login or Register  to view this content.

[Rajkumar_h]

Hello Kev,

Thank you so much for the solution.