Numbers 3.6.2 - How would you create a conditional formatting rule to highlight even or odd numbers? This is very easy in excel, can't get this to work in Numbers.
MacBook Pro with Retina display, macOS Sierra (10.12.3)
Hi Rusty,
Conditional Highlighting rules compare the value in the cell to be highlighted with either a fixed value, written into the rule, or to the value in another cell.
In your case, you want the rule to be triggered by any odd number (or by any even number), so you will need to use the second comparison and set up a second cell whose value you can manipulate to contain a value which may be compared with the value in the cell to be highlighted. Here's an example:
Changing the value in C1 to 1 changes the highlighting from being applied to the Even numbers to being applied to the odd numbers by changing the values in the control column, column D.
The rule is shown in the first image above.
The value in cells in column D is set by this formula, entered in D2, then filled to the end of column D:
IF(MOD(B,2)=C$1,B,"")
To remove highlighting from all cells in column B, set C1 to any value greater than 1 (or any value other than 0 or 1).
If you do not need the ability to switch from highlighting odd to highlighting even, replace the reference to C$1 with 0 (for even) or 1 (for odd) in the formula.
Column D may be hidden.
Regards,
Barry
Numbers Conditional Formatting
