3 Replies Latest reply on Dec 13, 2018 5:14 PM by Dave McManus

    Conditional Formatting based on string value

    steph c

      Hi all,

       

      I was wondering if there is a way to format my crosstab conditionally based on string value and not measure value

       

      Example, I have rows right now "First Name," "Last Name," and "Program Completion."

       

      Is there a way i can individually format with colour on the columns First Name and Last name based on the condition of "program completion" (ex. green = complete, white = in progress)

       

      ps. in the example screenshot attached, there is automatic grouping of first name; is there a quick way to have it ungrouped when exported to excel?

       

      Thank you!