Conditional Formatting by a control field

[Lily Driscoll]

I am trying to have cells highlight based on whether its 30,90,180 days before today. Is there a way that I can have the conditional read off a control field or set a relative time?

[Mohsin Shaikh · Accepted solution]

Hello @Lily Driscoll ,

This is Mohsin from Atlassian Analytics. I will assist you with this request. 

Unfortunately, applying conditional formatting on relative date variables isn't yet supported, however, we have an existing feature request for the same as below:
https://jira.atlassian.com/browse/ANALYTICS-219

I have personally watched the FR and added you, so we help gain more traction on its implementation and also so we receive notifications on it moving forward.

I would recommend that you upvote the same so that you help add more traction to its implementation and so you receive updates in the future as well.

Best Regards,

Mohsin