How To Highlight Odd or Even Numbers In Numbers?

Comments: 2 Responses to “How To Highlight Odd or Even Numbers In Numbers?”

Gary Rosenzweig

5 years ago

There is no Conditional Highlighting rule that looks for odd and even values. So you have to go with some other strategy. For instance, you can add a column to the right of the one with the numbers, then use an IF statement to check for odd or event values. If the value is in C2, then a formula for that would look like this:
IF(ISEVEN(C2),"Even","Odd")
A formula to count them would be:
COUNTIF(D,"Even")

Javed

5 years ago

Thanks Gary. Worked like a charm. You are providing a great service to Apple community and we appreciate it. I never missed your podcast.Please never stop this great work.Thanks once again.

I applied formula (IF(ISEVEN(C2),”Even”,”Odd”) in a new column next to the data column but I counted even and odd numbers at the bottom of the new column.Then I used conditional highlighting feature to highlight Even and odd number and it worked the way I wanted. Thanks once again