Number of decimals in a conditional format [Closed]

Question

Number of decimals in a conditional format [Closed]

Report

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: 2742
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: May 4, 2021

- 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 cell contains any date - How-To - Excel
Excel conditional formatting more than 3 colors ✓ - Forum - Excel
Conditional formatting merged cells ✓ - Forum - Excel
Conditional formatting if cell contains any text ✓ - Forum - Excel
Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2013-05-27T11:51:03-0400

Answer 1 / 1

TrowaD

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

460
May 27, 2013 at 11:51 AM

Hi Boon,

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

Best regards,
Trowa

Number of decimals in a conditional format [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!