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.
|