Compare contents of 2 excell woeksheets

Hello,

I am clueless about VBA Programming. I need help with a small piece of code. Following is my problem description...


The first 3 columns of Worksheet 2 need to be compared with the first column of Worksheet 1 and the result needs to be stored as coloured cells in Worksheet 1.

Worksheet 1 Worksheet 2
--------------- ---------------
Col A Col A Col B Col C
TRUE TRUE TRUE FALSE
FALSE TRUE FALSE FALSE
FALSE FALSE TRUE FALSE
TRUE TRUE FALSE TRUE
TRUE FALSE TRUE FALSE

After the matching, Worksheet 1 should look as follows... i.e the respective cells should be filled with green and red colours.

Worksheet 1
---------------
Col A Col B Col C Col D
TRUE GREEN GREEN RED
FALSE GREEN GREEN GREEN
FALSE GREEN GREEN GREEN
TRUE GREEN RED GREEN
TRUE RED GREEN RED


Please help. Thanks
SD