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):

Date	Type
4/1/15	Random1
4/5/15	Random2

<tbody>
</tbody>

Second data sheet (example):

4/1/15	4/2/15	4/3/15	4/4/15	4/5/15
(Green fill)				(Blue Fill)

<tbody>
</tbody>

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