Calendar fills cells automatically

Got a good one. I have a workbook which is basically a bank ledger. One tab for each month. It is just a table recording daily cash receipts and cash payments, with a running balance. The last tab is a set of mini calendars, which I would like each day to fill a color if there is an entry on that date/day in the corresponding month's tab. There should be at least one entry every day except Mondays and Wednesdays. Also, the Transaction column would need to say "Contribution" for that transaction type in order to qualify to fill a color. You will see the July tab has 29 entries on the left hand table (this is the only table that needs to have the entry, ignore the right hand table). Given the entries, the July mini calendar on the Calendar tab should have the dates/days shaded for any corresponding entry on the table. I am basically just trying to make an easy visual to see what days I have not recorded the "Contribution" transaction. So ultimately at the end of the month, every day except Mondays and Wednesdays should end up being shaded as long as I have recorded a "Contribution" transaction for the day. In this example, I am missing Thursday the 4th, Thursday the 11th, and Friday the 19th "Contribution" transactions. So along with all Mondays and Wednesdays, those three days should not be filled, but all others should. I hope that makes any sense. Please let me know if I can better explain.

Thanks!

Do you wish to have a macro for this / or expecting some kind of formula to do this? I think I can build a small macro to suffice your requirement.

Originally Posted by nikhild64

Do you wish to have a macro for this / or expecting some kind of formula to do this? I think I can build a small macro to suffice your requirement.

I guess what I was hoping was when I add an entry to the table and label the transaction as contribution, that the day on the mini calendar automatically fills. I'm not sure if it's vba or formulas that could make that work. I'm assuming both could work, but I can't figure out how.

You can do that with conditional formatting
Select B3:H7, in CF New rule > Use a formula & use
=ISNUMBER(MATCH(DATE("2019",MONTH($B$1&1),B3)&"Contribution",INDEX('July 2019'!$B$4:$B$100&'July 2019'!$D$4:$D$100,0),0))

For reference here's your workbook with the Cf set for both July & August