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

Conditional formatting based on date


jmborzick
QPN Level 5 ●●●●●
Forum|alt.badge.img+39

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.

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

jmborzick
QPN Level 5 ●●●●●
Forum|alt.badge.img+39
  • QPN Level 5 ●●●●●
  • 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.


Leave a Reply