Condition Formatting on Date Values in a Pivot Table

Hi All,

I'm attempting to create a live matrix of upcoming due dates, sourced from a series of appended external tables, I have all the connections stable. The final bit (the bit I need assistance on) is using the conditional format "date occurring" on an entity within the "values" section of my pivot table, however, it is greyed out... not happy 😞

I've tried to get around it with greater than/less than/between formatting but the formatting does not highlight cells according to my rules of "=Today()" "=Today()+7" etc... this is what i have right now (ignore the 1900 dates)

vs what I want using the conditional formatting:

Any tips and tricks would be greatly appreciated 😄