Conditional color formatting

Q&A
, ,
1

Hello,

How can I do a conditional formatting on a table that has due dates, with the ones closest to being due appearing red, and the ones farthest being green, with a special formatting (maybe bold?) to show the most recent entries to the table?

thanks
eh

2

Hi @hdezeduardo
Please have a look at.

Maybe you need to calculate the closest one.
BR

3

You can achieve it by below steps

  1. Create a calculated field (e.g. max date) to find out the max transaction date in your record by using function maxOver
    image

  2. Compare the max date with the date in each record by using function dateDiff
    image

  3. The record with dateDiff value equal to zero is the latest record. Then you can apply conditional formatting base on this column

    image
    image1097×539 88.3 KB

You may use the same logic to find out the oldest record and apply conditional formatting