Hey there, I have a monthly calendar workbook that contains two sheets. The first sheet is a data table and the second sheet is the monthly calendar which displays the data from the table. I have userforms that make data entry easy. I cannot figure out how to make the calendar display the data with the cell’s full color equal to the value of the “Color Code” column in the table. Also, when I click on a date to start editing the data, the userform messes up the date format.
128.5 KB Views: 9