2 Replies Latest reply on May 23, 2020 12:48 PM by Rene Venema

    Always Fixed Color for a Category


      Hi All,

      Every time I need to work on any analysis, I need to define the conditional formatting for each category. Is there any easy way, where I can save my conditional formatting or add a color code column in my data and save the time a and effort behind this.


      Category A will always be displayed as Gery

      Category B will always be displayed as Orange

      .. and so on.


      I want to avoid re-defining this in every workbook I work. Any thoughts or help would be appreciated.

      Thanks in advance.