7 Replies Latest reply on Jun 21, 2018 11:18 AM by Deepak Rai

    Conditionally color cells based on text from another column

    Logan Butler

      I am trying to highlight one of the cells per row in a grid based on the text from another cell. In my example below, I have a test with the correct answer listed, and how many students chose each of the options available. I would like to highlight the correct cell.

       

       

      Is there any way to do this? In theory I could highlight the cell with the highest value too, but that cannot be guaranteed to be the correct answer always