Hi Johan,

Am Sat, 20 Jul 2019 03:04:10 -0700 (PDT) schrieb JS SL:

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

sorry, I misunderstood the question.
Download the new file from here (macros are disabled in OneDrive):
https://1drv.ms/x/s!AqMiGBK2qniTgeVo...vk79w?e=dC5RV5


Regards
Claus B.
--
Windows10
Office 2016