Nested loop problem

[gibbsa08]

Hey guys,

This should be a relatively easy fix. I'm looking to loop through an arbitrary number of columns and rows in a worksheet (in this example n=20) and color cells if the cells value matches any values in a one-dimensional array. The ultimate goal of this macro will be to color code these cells to create a heat map linked to the frequency of occurrences of the given events stored in the array. The current code loops through the columns and rows but is highlighting everything in red when it should be only highlighting those cells with values that match the values stored in the array. Thanks for the help in advance!

Sample array:

array.JPG

Sample heat map:

floor.JPG

Please Login or Register  to view this content.

[Pete_UK]

You need to change this line in your macro:

Please Login or Register  to view this content.

so that you are looking for an exact match.

Hope this helps.

Pete

[gibbsa08]

Could someone explain how I should go about coding the array and cells with an exact match?