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 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*** |
1 Reply
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:
