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?

Try the following formula as CF :

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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.

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.

Forgot to remove the semi colon
and apply to the entire column ( you might get some surprises, though)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

This way of doing might surprise you

First, try =len(MOD(7.1092,1)) answer is 6
Now try =len(MOD(7.10,1))
Which answer do you get ?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

thanks Pecoflyer!!