Conditional format one cell based on two other cells matching

[manzier]

Hi all,

I need help figuring out how to conditional format one cell based on two other cells matching. I have the main data sheet where the dates are. Then on another tab I have each day of the month listed out and below it a blank square (think of a calendar). When there is activity on a date in the main data sheet, i want the square below the corresponding date in the other sheet to turn a certain color.

To make it even harder, I'd like the color to be a different color based on another column in the main data sheet.

Not sure how to go about this

Main data sheet (example):
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TD]4/1/15[/TD]
[TD]Random1[/TD]
[/TR]
[TR]
[TD]4/5/15[/TD]
[TD]Random2[/TD]
[/TR]
</tbody>[/TABLE]


Second data sheet (example):
[TABLE="width: 500"]
<tbody>[TR]
[TD]4/1/15[/TD]
[TD]4/2/15[/TD]
[TD]4/3/15[/TD]
[TD]4/4/15[/TD]
[TD]4/5/15[/TD]
[/TR]
[TR]
[TD](Green fill)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD](Blue Fill)[/TD]
[/TR]
</tbody>[/TABLE]



Thanks for the help!

 

[etaf]

you should be able to do with an index/match or vlookup()
But will the colour be specific to the content on main data sheet
ie
Random 1 = green
Random 2 = blue

how many items will there be in type

what version of excel

can you perhaps put a sample sheet on a share like dropbox or onedrive