I am looking to use a date difference function to create a formula to quantify if a date is in a Red,Amber,Green status. There is no problem in creating this as a formula field but I am looking to use the result to colour the date with its associated colour. Does anybody know a simple way of doing this in a table view?
Thanks Antonio, looking at this am I only able to do this with one column? as I have multiple columns I need to be formatted in this way all within a single table
You can only select one Field in the "Coloured by" > "By Single column" option, but you can select more than one field in the Click on "Coloured by" > "Columns enabled" option, in order to colour multiple fields.