Thread: Conditional Formatting for values with more than 2 decimals
View Single Post
 
Old 04-15-2015, 01:35 PM
lynchbro lynchbro is offline Windows 8 Office 2010 64bit
Advanced Beginner
  
Join Date: Jun 2014
Location: New York
Posts: 41
lynchbro is on a distinguished road
Default Conditional Formatting for values with more than 2 decimals
I have a column of data (Column L) that I wish to highlight with conditional formatting if the values populated are greater than 2 decimals out.

For example:
38,519.79 would not be highlighted
38,519.7899 would be highlighted

Would this be conditional formatting with the use of a formula?

Reply With Quote