Hello Excel Gurus,
Is it possible to replace a value with a blank using Excel's custom formatting? Meaning I have text from PivotTables "Values" as when nothing is selected it shows (All) .
I would like to replace the text "(All)" with that of an empty cell. I have access to Custom Formatting within this cell but not sure if it is possible to achieve it or not. Or perhaps if I could shift the color to white text when (All) is typed in?
From this :
To this :
Will appreciate any help.
Is it possible to replace a value with a blank using Excel's custom formatting? Meaning I have text from PivotTables "Values" as when nothing is selected it shows (All) .
I would like to replace the text "(All)" with that of an empty cell. I have access to Custom Formatting within this cell but not sure if it is possible to achieve it or not. Or perhaps if I could shift the color to white text when (All) is typed in?
From this :
To this :
Will appreciate any help.