6 Replies Latest reply: Apr 21, 2016 1:20 AM by Bob Dylan RSS

    Cell background colour based on cell's value

      I have a Table Box object and one of the columns (Status) will always contain a string of either 'IN' or 'OUT'. I have gone into Custom Cell Formatting and attempted to change the background to a function like so:

       

      IF([Status]='IN', LightBlue(), LightGreen())

       

      But it only equates to true if ([Status]='IN' after selection, but I would like the fields to be colour coded without having to select anything. I thought fieldValue() might help me but wasn't sure how to use it.

       

      Something like

       

      IF(THISVALUE='IN', LightBlue(), LightGreen())

       

      ??

       

      Thanks.