Conditional formatting with special characters

[malshand]

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 value

57.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***

[#2]

@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: