compare values on columns

[djharrison]

Greetings,

I am try to compare values between cells in 6 columns to determine if
there is a positive correlation between values. My data looks similar
to below (1981 records in total).

Row1 Col1 Value1 Row2 Col2 Value2
1 1 1 4 0
1 2 1 5 2
1 3 1 6 0
1 4 0 1 7 0
1 5 2 1 8 0
1 6 0 1 9 0

I would like to to determine If Row1 = Row2 and Col1 =Col2 and Value1
= Value2
If this is true there is a positive correlation and I would like to
output a "Yes" or "No" text to a cell for each record in another
column named "Correllation". An additional complication is the NULL
value present in some of the Value1 cells. These can be treated as 0.

I am new to VBA in Excel but not a total novice at VBA. Can I use
conditional formatting or a macro or such and if so I would
appreciated any suggestions or code that anyone has to offer.

Thanks,

Daryl

 

[djharrison]

Thanks for the help Dan. I was mixed up on the syntax. Works great now.