Custom formatting

[DJ]

Hi,


In reference to the technique mentioned at link: http://chandoo.org/wp/2012/05/07/displaying-text-values-in-pivot-tables-without-vba , I want to know if this technique can be used to display a different text in place of the actual text. I tried but it didn't work. Please suggest if any workaround is possible.


Thanks,

DJ

 

[Hui]

DJ


You can only place text values into ranges of Numeric values using a custom number formats like:

[>=1]"Yes";[<1]"No";