This is hard to describe but the attachment has the example. I have a 365 grid calendar and below it a table with Rows: Date, Type, Details. In to that table we input the date that an employee has received a caution.



What i want to do is have the data also appear on the grid calendar above for example, an employee receives an informal warning on 12/3/19 and i want that information (once entered in to the table) to turn the corresponding cell on the calendar to the appropriate colour and code for an informal warning. Which in this example would be a red cell with the letters "IW" in it on the grid under the cell for 12/3/19.


Edited to remove file password

Attached Files

Employee At A Glance.xlsx (23.3 KB, 8 views)