However, its a bit different. I have a Trainings Table with records of all Trainings/Certificates our employees need. These records are being used as fields at the top of my pivot table. On the left side are Employee Names coming from an Employee Table. Thirdly, there is a CertificateTable that pulls them together. This table consists of the employee name, trainer, training, issue and expiration dates.
The Values for this Pivot Table are the Expiration Dates in short date form, which is a field in the CertificateTable. Is there a way I can make the cell alone (not the entire column or row) turn red if that date is within 30 days of expiring?
I can't insert an HTML Block on the Pivot Table Wizard, however it allows me to insert a header and footer.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
kpcollier
Trying to do something similar to this post
However, its a bit different. I have a Trainings Table with records of all Trainings/Certificates our employees need. These records are being used as fields at the top of my pivot table. On the left side are Employee Names coming from an Employee Table. Thirdly, there is a CertificateTable that pulls them together. This table consists of the employee name, trainer, training, issue and expiration dates.
The Values for this Pivot Table are the Expiration Dates in short date form, which is a field in the CertificateTable. Is there a way I can make the cell alone (not the entire column or row) turn red if that date is within 30 days of expiring?
I can't insert an HTML Block on the Pivot Table Wizard, however it allows me to insert a header and footer.
Thanks.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.