conditional formatting error?

[Want2BExcel]

Can anyone tell me why conditional formatting doublet is colouring this data? The formatting in cells are text.
And it gets even more weird. If I delete the first character in the top greens, the doublet colouring disappears for the first two, but then, by the 3th it "lights up the one above again, as if the two was identical...WTF???

 

[Joe4]

Can anyone tell me why conditional formatting doublet is colouring this data? The formatting in cells are text.
And it gets even more weird. If I delete the first character in the top greens, the doublet colouring disappears for the first two, but then, by the 3th it "lights up the one above again, as if the two was identical...WTF???
View attachment 103485 View attachment 103486 View attachment 103487

We need a bit more detail in order to be able to help you.
Please post the exact details of the Conditional Formatting Rule you are using.
And let us know what the exact range is of the image you are showing above.
And lastly, let us know exactly what you WANT this Conditional Formatting to do.

 

[Want2BExcel]

We need a bit more detail in order to be able to help you.
Please post the exact details of the Conditional Formatting Rule you are using.
And let us know what the exact range is of the image you are showing above.
And lastly, let us know exactly what you WANT this Conditional Formatting to do.

It turns out that it wasn't an error with conditional formatting....just a formatting error (which I still don't know how to correct)
Maybe it requires a new post, since it's a different problem?

The data in cell is formatted as text (notice the red circle), but excel "reads" it as number (Pic1) and when I try use the text function (Pic2) it "cuts" the last 3 characters (and that was why the conditional formatting was acting "weird" since the last 3 characters is unique for be able to differentiate one from another and my formula is counting 6 and not 1 as it should)
Is there a way to correct this "error"?

 

[Joe4]

Yes, that really is a different question.
Note that for numbers, Excel can only store up to 15 significant digits. It will convert any others after that to zeros ("0") like you are seeing.
If you enter a value in as a number, it will automatically convert everything after the 15 digits to 0.
Once it is entered like that, you cannot get the original digits back. You need to FIRST format the cell as Text, BEFORE entering the value.

 

[Want2BExcel]

Yes, that really is a different question.
Note that for numbers, Excel can only store up to 15 significant digits. It will convert any others after that to zeros ("0") like you are seeing.
If you enter a value in as a number, it will automatically convert everything after the 15 digits to 0.
Once it is entered like that, you cannot get the original digits back. You need to FIRST format the cell as Text, BEFORE entering the value.

I'm aware of this. But the table containing the data comes from an access db, where the data is "short text". Then a power query pulls the data out, also recognizing it as text and loading it into a table, where it looks like text but for these few cells (out of 5000+) Excel treats it as a number. I don't even get why Excel puts in a comma, when there is none in the cell

 

[Want2BExcel]

I'll make a new post. Thx for the response though