Hi Claus,

The problem/challange is that the text/values are registered in the same cell.
So, for example;

A2= 200,000 - 210,7
B2= '-' - 200
C2= 202,1 - '-'
D2= 150 - 140

It are values in a cell as text and in between the 2 values a split -
The way you shows is normal single values in a cell. As you mentioned, yes you can solve this then easy with conditional formatting.
Excuus if I didn't explain that part clear enough

regards, Johan