• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formatting

GN0001

Member
I have a column and I want to only color only numbers that the three first digit equals to 123.


I went to conditional formatting. I selected; use a formula to determine which cell to format.


I entered this formula;

=right(D2,3)=123, fill it with some certain color. But this didn't affect my column:


789654123

456321456

125246123

748962213

155742789

587857584

415452874

415425789


What is the problem?

Regards,

Guity
 
Hi Guilty,


You are doing a text test against a number.


Try rhe following, note this will only work provided your number is 9 digits long


=A3-MOD(A3,1000000)=123000000


kanti
 
Kchiba,

I tried this : Value(Right(cell,numOfDigits)=123 and I got the answer. Anyway, I will try this formula as well.

Thank you very much,

Guity
 
Kchiba,

I tried this : Value(Right(cell,numOfDigits)=123 and I got the answer. Anyway, I will try this formula as well.

Thank you very much,

Guity
 
Kchiba & Luke M,

This A3-MOD(A3,1000000)=12300000 doesn't work. I need to reach 123, not 12300000. Since I got the answer, I am not bothering about it. I can use either VALUE(RIGHT(D2,3))=123 or RIGHT(D2,3)="123".

Regards,

Guity
 
Back
Top