Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 04-16-2015, 01:14 PM
Jhnsnkth527 Jhnsnkth527 is offline Conditional Formatting for values with more than 2 decimals Windows 7 64bit Conditional Formatting for values with more than 2 decimals Office 2010 64bit
Novice
 
Join Date: Apr 2015
Location: Cincinnati
Posts: 7
Jhnsnkth527 is on a distinguished road
Default

Try the formula based condition if
MOD($L1,.01)>0

MOD is basically a "remainder" function. Example, 7.1 divided 1 has a MOD of .1, I'm guessing if you move the decimal two places (.01), it will give you a MOD for the extra. Example 7.1092 divided by .01 should have a MOD of .92

NOTICE:
Using conditional formatting based on a formula, you can select the cells in column L (i.e. applies to $L$1:$L$2000 or $L:$L), but the conditional formula is
=(MOD($L1,.01)>0)
where $L locks the column but the 1 without the $ says to evaluate each cell based on their own row.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting for values with more than 2 decimals 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 for values with more than 2 decimals 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 10:23 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft