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?
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.
P.S. Evening Phxsportz, thanks for your inputs in both debates!