Forum Discussion
Conditional Formatting, Expiry dates on Matrix Visual
I am having nearly the same problem and am eager to find a solution. I need conditional formatting for date fields in a matrix visual with the value being compared to the compliance date for the specific training category in the Courses table. If the value date is earlier than the compliance date, the value would be bold red text and if the value date is 1-90 days after the compliance date, the value would be highlighed yellow. There are some trainings that only have to be completed one time and the compliance date for those is blank in the Courses table.
Due to my organization's IT policies, I'm not able to provide a link to even sample data but have provided screen shots of my report and the relationships established in my data model in hopes that will be enough information. I can provide more screenshots if it will help to develop a solution.
Thank you,
D
I cannot assist you if you are unable to provide sample data. I hope someone else can help you further.
- Drae2 years agoNew Member
Hi,
I'm just trying to figure out how to upload the data. Currently covering multiple absences at work so I'm a little slow to respond at the moment. Sorry 😞