Question
I have got 3 tables:
Calendar
Id Date 1 1/1/2018 2 2/1/2018 3 3/1/2018
Customer
Id Name Start_Date 1 Matthew 1/1/2018 2 Jake 2/1/2018 3 Els 3//1/2018
Reservation type
Id Reservation type 1 AM 2 PM 3 D
Now I got a query that populates a table that show per date which customer has which type of reservation, resulting in table:
Id CalendarId CustomerId ReservationTypeId 1 1 1 1 2 1 2 1 3 1 3 3 4 2 1 1 5 2 2 2 6 2 3 1 7 3 1 3 8 3 2 2 9 3 3 1
I have created a Crosstab query which lists the Customers as Row headings, the Date as Column headings, and the Reservation Type as Value. I have limited the colums by showing only dates for the current week. This results in:
1/1/2018 2/1/2018 3/1/2018 Matthew AM AM D Jake AM PM PM Els D AM AM
Question:
How to color the background of the cell where the Date in the column headings equals the Start_Date of the corresponding Customer.
Thus in the scenario above,
cell Matthew - 1/1/2018 should be colored
cell Jake - 2/1/2018 should be colored
cell Els - 3/1/2018 should be colored
Thank in advance.
Kind regards,
Bart