Number of decimals in a conditional format

Closed

boon1d

Posts: 2
Registration date: Wednesday May 22, 2013
Status: Member
Last seen: May 27, 2013

- May 27, 2013 at 09:00 AM
TrowaD

Posts: 2886
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: June 27, 2022

- May 27, 2013 at 11:51 AM

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

Number of decimals in a conditional format
Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel
Conditional formatting excel if another cell contains text ✓ - Forum - Excel
Excel conditional formatting 5 color scale ✓ - Forum - Excel
Conditional formatting if another cell is blank - Forum - Excel
If cell contains date then conditional format - Guide

1 reply

Answer 1 / 1

TrowaD

Posts: 2886
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: June 27, 2022

515
May 27, 2013 at 11:51 AM

Hi Boon,

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

Best regards,
Trowa

Subscribe To Our Newsletter!