MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How To Highlight Odd or Even Numbers In Numbers?

I am trying to use conditional highlight feature to highlight odd and even numbers and then count the odd and even numbers .
Thanks
—–
Javed

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

    11 months 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
    11 months 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

Comments Closed.