Forum Discussion

melina's avatar
melina
Helper IV
9 years ago

Color row based on date condition

Hi,

Can i formatting the table in Report (desktop) and dashboard, for example in one table i want to change row colour based on date condition, for the pass date i want the table row became red,current date the table row became blue. If yes, what language i need to use and how. Thanks

Show and Tell

7 Replies

  • deldersveld's avatar
    deldersveld
    Resident Rockstar
    9 years ago

    There is conditional formatting based on column values but not by the entire row.

    • melina's avatar
      melina
      Helper IV
      9 years ago

      Thank you for your reply,

       

      Ok, if cannot color by 1 row, could i apply to font color or background color in one coloum.

      Let say for example, i have 2 coloums, SO number and Closing date.


      If date in Closing date is passed, font or background color will color in red.

      If date in Closing date is current date or upcoming date, it will color in blue.

      The scenario example as below:

       

      Can it be apply in report visualization?

       

      SO Number

      Closing Date

      87384374

      01/04/2017

      98972777

      03/04/2017

      87293839

      20/04/2017

      83749848

      01/05/2017


      Appreciate if you could help me to solve this problem.

      Thanks!