Number of decimals in a conditional format [Closed]

Report
Posts
2
Registration date
Wednesday May 22, 2013
Status
Member
Last seen
May 27, 2013
-
Posts
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 2021
-
Dear reader,

I need to highlight a cell that contains more than 2 decimals.
ex. 2,89 is good and should not be highlighted
2,899 is wrong and should be highlighted but the amount of decimals should not change. Is this a possibility with conditional format?

Many thanks in advance

Kind regards

1 reply

Posts
2742
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 4, 2021
460
Hi Boon,

Try this formula:
=LEN(A1)-LEN(TRUNC(A1))>3

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!