Formula help odd numbers

[Runes]

Ok I have a table where 2 columns cannot have odd numbers. I have a conditional format in place that turns the boxes red when and odd number is used but I need a warning to pop up saying "no odd numbers" in another box. I can get it to work for one box but when I try to get it to cover both columns it does not work. This is what I am using currently for my formula but as you can see it only covers one box IF((MOD(C5,2)<>0),"NO ODD NUMBERS!",""). I have tried to get both columns in here but it does not work. Can I include this in my conditional format as a second condition? Right now it is a separate formula in the box, which is fine also. I need the box to turn red (which it does) and say the above.

Any help would be appreciated.

 

[Akashwani]

Hi.

Have you tried Data Validation?
You can highlight each column and apply a Data Validation message to be displayed when any of the cells are selected.
Or you can use this formula in DV to prevent the user from entering an odd number....
=MOD(C5,2)=0
C5 being the first cell in the column.

I hope that helps.

Ak

 

[Runes]

That worked beautifully -- thank you so much.

 

[Akashwani]

Hi, thanks for the feedback, I'm pleased it worked for you.

Ak