Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

conditional formatting icon not visible

Hi,

 

I have the dataset in the below format and the result that i want is partially obtained as shown in screenshot 2 , the conditional formatting icons are not visible for color codes 2  & 3, am not sure where am going wrong.

 

Note: I had unpivoted 3 different date columns 

 

 

 

7 Replies

  • Hi Anonymous 

    Change Percent to Number in the rules

    regards

    Phil

    • Anonymous's avatar
      Anonymous
      Not applicable

      @amitchandak , am not able to attach the file, but here is the screenshot of sample database

      Expected result is to see icons for all the dates

      2020-12-15 12-33-10_New Microsoft Excel Worksheet - Excel.jpg

  • HI Anonymous 

    What do your CF rules look like?  This should work

    Phil


    If I answered your question please mark my post as the solution.
    If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

    • Anonymous's avatar
      Anonymous
      Not applicable

      PhilipTreacy , i tried the same conditions still not working, the icons are visible only for color code 1