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):
<tbody>
</tbody>
Second data sheet (example):
<tbody>
</tbody>
Thanks for the help!
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!