Number of decimals in a conditional format
Closed
boon1d
TrowaD
- Posts
- 2
- Registration date
- Wednesday May 22, 2013
- Status
- Member
- Last seen
- May 27, 2013
TrowaD
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Related:
- 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
TrowaD
May 27, 2013 at 11:51 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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