Matching multiple id's to criteria in a list

[Bennett9988]

Hey,

Hope somebody can help me with this excel conundrum.

I currently have a yearly overview planner with the weeks of the year, where we plan certain activty frequency, but the actual report of the activity leaves me with a very long list of activity ID's and the week they were done.
I need to somehow match these so the overview planner can be updated automatically (with some conditional formatting in place).
Problem with Vlookup is obviously it only finds the top data record, so I have no history in my overview. I have an example file but don't know how to upload it (as I dont think I'm allowed?)
Where x represents I want to indicate the task was found to be done.

OVERVIEW REPORT LIST
_1 2 3 4 5
A x x x x x
B x x x x x
C x x x x x
D x x x x x

REPORT LIST
D 4
A 3
C 3
B 2
C 2
A 1

Thanks for any help or advice anyone can give.

MxB

 

[venkat1926]

there is a function countcolor by Pearson

http://www.cpearson.com/excel/colors.aspx

 

[Bennett9988]

Thanks for the heads up matey, Ill check that out.