Conditional formatting based on date | XM Community
Skip to main content
Question

Conditional formatting based on date

  • August 16, 2024
  • 2 replies
  • 44 views
jmborzick
QPN Level 5 ●●●●●
Forum|alt.badge.img+41
  • jmborzick
  • QPN Level 5 ●●●●●
  • 261 replies

I have a record table with several dates. Is there a way to use conditional formatting with a date field? 

 

If not, can anyone come up with a workaround? The dashboard is pulling from the directory.

2 replies

chackbusch
QPN Level 5 ●●●●●
Forum|alt.badge.img+22
  • chackbusch
  • QPN Level 5 ●●●●●
  • 415 replies
  • August 16, 2024

@jmborzick Did you check this?

https://www.qualtrics.com/support/vocalize/dashboard-settings-cx/dashboard-data/advanced-fields/custom-date-formats/#ChangingAFieldsDateFormat

Driving Qualtrics @ MHP – A Porsche Company 🚀
jmborzick
QPN Level 5 ●●●●●
Forum|alt.badge.img+41
  • jmborzick
  • Author
  • QPN Level 5 ●●●●●
  • 261 replies
  • August 16, 2024

@chackbusch Thank you, but I’m not looking to change the format of the date, but rather use conditional formatting. With numeric fields you can have the cell highlight if the value is greater/less than another value. I’d like the same thing with dates. 

 

For example, a date after “today” would be red, a date equal to “today” would be yellow, and a date before “today” would be green.


Terms & ConditionsAccessibility statement