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 would not need to remove the asterik mark as it is required in my work and please help how can I still perform conditional formatting with * mark in data set.

F value57.58***22.55***20.22***15.28***226.21***208.11***2.91*37.35***57.95***19.84***17.41***7.19***73.56***4.58**145.09***61.57***14.46***33.24***51.74***

​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 would not need to remove the asterik mark as it is required in my work and please help how can I still perform conditional formatting with * mark in data set. F value57.58***22.55***20.22***15.28***226.21***208.11***2.91*37.35***57.95***19.84***17.41***7.19***73.56***4.58**145.09***61.57***14.46***33.24***51.74***  Read More

​