Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Color scale for dates in table

Hi -  Is there a way to apply Conditional colors by creating a table based on the age of a record?   Example:  a record was:   Updated last 7 days - green Last update 8-30 days - yellow Last u...
  • jthomson's avatar
    8 years ago

    I'm not sure if it's possible to conditionally format on the date field itself, but if you create a custom column Age = INT(TODAY()-[your last update column]), it should give you a value as an integer which you can then conditionally format based on the rules you have