14 Replies Latest reply: Jun 11, 2015 6:29 AM by Piet Hein van der Stigchel RSS

    Change Sheet Colour Background using GetCurrentSelections

    Imtiaz Ullah

      Hi guys,

       

      Not sure if this is the right way to achieve this, but I am trying to change the background colour of a sheet depending on a particular selection within a dimension.

       

      I am currently using - =if(GetCurrentSelections(SurveyQuestions)='TEXT TO LOOK FOR',yellow(),white()) and although I know the current selection text is correct (am throwing it out to a textbox), the colour of the sheet doesn't change.

       

      Perhaps there are better ways to achieve this?

       

      Thanks

      Immy