4 Replies Latest reply on Jun 12, 2018 5:43 AM by Vimal Annamalai

    How to do conditional color coding for all rows & How to display selected filter values in label?

    Vimal Annamalai

      Hi All,


      I have two requirements like below:-


      Requirement 1:-



      - > How to color code each every row based on the condition like if value > 0 Then 'Green' else 'RED'?



      Requirement 2:-


      - > How to display two different sheets selected filters values as label header in one new sheet (Note:  Should not be as sheet header, requirement is for label header)?



      Sheet 1 Filter


      Sheet2 Filter



      I tried to create a label Header but it is not displaying as expected



      When i remove any of the one filter, it shows some what expected results  but not satisfying full requirement. Below screenshot shows when i remove Branch2 filter from the sheet Header Requirement sheet.




      Yellow highlighted above should display 'A' as selected from Branch2 filter but not.


      I have attached my sample sheet too.  Your help will be appreciated more.


      Thanks in Advance.