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.
Any help would be appreciated.