I am trying to set up conditional formatting on all rows that have a number column A ending in .2
I have two possible formulas to check the applicable cell for number ending in .2. However both formulas have the same problem. They return 0.2, but the formula =[RESULT]=0.2 returns FALSE.
Formula 1: =A1-TRUNC(A1)
Formula 2: =MOD(A2,1)
Any ideas what is wrong and what will work right?
Bookmarks