I have a large table in which I have three columns of numbers. I only use even numbers so I need a formula for my conditional formatting to look for any odd numbers in these columns and turn the cell red when it finds one. Can you suggest anything?
You can use MOD function, e.g. if your numbers are in columns A to C then just select those 3 columns and use conditional formatting with "formula is" option and this formula
=MOD(A1,2) works good, but fails within a big numbers, say if A1 is equal to 1000000001
There is the formula for the full range of Excel numbers:
=TRUNC(A1)/2<>TRUNC(TRUNC(A1)/2)
You cal also use the Analysis ToolPak Add-In's function IsEven() in this manner: =Not(IsEven(A1))
But such Add-In should be checked in the listbox of menu Tools > Add-Ins
Such formula returns the different result than =Not(ISEVEN(A1)) and than of mine, for example if A1 = 2.5 or A1 = -2.5 etc.
Taking into account that ISEVEN() now is integrated into the current version of Excel 2007 and it not requires the Analysis ToolPak Add-In, I think that the compatibility with ISEVEN() would be the de-facto rule.
Regards,
Vladimir
P.S. Evening Phxsportz, thanks for your inputs in both debates!