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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
odd numbers
- Thread starter Runes
- Start date
ZVI
MrExcel MVP
- Joined
- Apr 9, 2008
- Messages
- 3,875
- Office Version
- 2019
- 2016
- 2010
- Platform
- Windows
Agree with you Barry. So Excel function ISEVEN() truncates the number to the integer without mathematic rounding and then applies the common mathematic even-rule to it. Seems that it's the new (or old as it's from XL97 ?) word on mathematics from MS.
Yea Phxsportz, one more beer - cheers!LOL... This is the same direction that yesterdays thread took... heh
Last edited:
Upvote
0
Excel Facts
Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
