Forum Discussion
Conditional formatting with special characters
Hi I'm applying conditional formatting-color scales from highest to lowest values for below statistical data. However the formatting doesn't get applied as this contains asterisk (*) in the range. I ...
malshand You don't need to remove the * marks but if you could split the values in a number and * into two columns. Then you will achieve an effect like this: