Microsoft Office Forums - View Single Post - Conditional Formatting for values with more than 2 decimals

Thread: Conditional Formatting for values with more than 2 decimals

View Single Post

Old

04-16-2015, 11:44 AM

lynchbro

lynchbro is offline

lynchbro uses Windows 7 64bit

Windows 7 64bit lynchbro uses Office 2010 32bit

lynchbro uses Office 2010 32bit

Office 2010 32bit

Advanced Beginner

The original poster

Join Date: Jun 2014

Location: New York

Posts: 41

lynchbro is on a distinguished road

Default

I tried that and it is saying it contains an error.

=LEN(L1&"")-FIND(".";L1&"")>2

Although I need it to look at the entire L column.

Reply With Quote