7 Replies Latest reply: May 4, 2018 9:46 AM by Shubham Manoj 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())