Previous Topic Next Topic

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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - 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
Related:

1 reply

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 547
May 27, 2013 at 11:51 AM
Hi Boon,

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

Best regards,
Trowa
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Unsupported signal. Please check device output
S.Agnew -
rockstar450 -

13 responses
Conditional format based on another cell containing text
stakik -
Corrina66 -

5 responses