Conditional Formatting for values with more than 2 decimals

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional Formatting for values with more than 2 decimals

04-16-2015, 11:44 AM

lynchbro

Windows 7 64bit Conditional Formatting for values with more than 2 decimals

Office 2010 32bit

Advanced Beginner

Join Date: Jun 2014

Location: New York

Posts: 41

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting	bbutl027	Excel	15	12-05-2016 08:56 PM
Conditional Formatting	sdfrance	Excel	3	01-06-2015 07:10 AM
Convert numeric values with decimals to alphabets	kjxavier	Word	1	07-06-2014 01:44 AM
Conditional formatting that ignores other formatting rules	info_guy2	Excel	1	07-03-2014 10:07 AM
Conditional Formatting	namedujour	Excel	3	08-25-2011 01:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:56 PM.