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 December 27, 2022 - May 27, 2013 at 11:51 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 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
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:
- Number of decimals in a conditional format
- Kingston format utility - Download - Storage
- Format factory - Download - Other
- Swissknife format - Download - Storage
- Marksheet format in excel - Guide
- How to change date format in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
May 27, 2013 at 11:51 AM
May 27, 2013 at 11:51 AM
Hi Boon,
Try this formula:
=LEN(A1)-LEN(TRUNC(A1))>3
Best regards,
Trowa
Try this formula:
=LEN(A1)-LEN(TRUNC(A1))>3
Best regards,
Trowa
