I have searched for this. I have tried to retrofit other conditional formatting threads. I thought I was close but couldn't get it to function. I figure this is easy and I am just on brain melt.
I am trying to make a dynamic shift calendar and when someone changes the operator who is on...
I have a calendar table with the following columns
Date. . calperiod commperiodnumber
15/3/2018. 3. 3
30/3/2018. 3 4
This is linked to a transaction table on date=transdate with following columns