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?
ADVERTISEMENT
ADVERTISEMENT
Hi Barry,If you have numbers that large then I think the simplest alternative would be:
=A1<>EVEN(A1)
Note that you can't use Analysis ToolPak functions like ISEVEN in conditional formatting