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!
Bookmarks