5 Replies Latest reply on Jan 22, 2018 7:43 AM by Glenn Kuly

    Colouring different dimension date field if over a year old

    sally ball

      Hi,

       

      I have a workbook where dimensions have been pulled onto the Row shelf, from a filter of 'current client group' its essentially:

       

      ROW SHELF: Client ID, Name, Date of Assessment a, Date of Assessment B, Date of Assessment C

       

      I need to be able to colour any dates that are over a year old from today as red and any within a year as green, this could be the background or the test - doesn't matter which as long as I can highlight the difference.

       

      I've attached a workbook with the details, and want to see something similar to the excel result doc attached if possible??