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
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