Previous Topic Next Topic

Number of decimals in a conditional format

Closed
boon1d Posts 2 Registration date Wednesday 22 May 2013 Status Member Last seen 27 May 2013 - 27 May 2013 à 09:00
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 27 May 2013 à 11:51
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 response

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
27 May 2013 à 11:51
Hi Boon,

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

Best regards,
Trowa

Similar discussions

Publisher?
macduffpiper -
TrowaD -

3 responses
How can I publish a study that I have done on this website?
simonrasho -
Daniel_CCM -

1 response
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response