Conditional Formating

Changing the colour of letters or numerals triggered by a specific value in another cell is a task for Conditional Highlighting.

These rules all involve comparing the value in the cell to be highlighted to a fixed value written into the rule or to a changeable value in another cell.

Your highlightable value is a "Numeric" value, which can be equal to, more than, less than, or not equal to the value it is compared to.

To provide a useable comparison value, you will need a partner cell containing a numeric value that can be compared with the numeric value in the cell to be highlighted, and that is determined by the string value in the control cell.

Here's an example:

C2 to C8 contains the values to be highlighted, Column E contains the cells with the 'text value' that is to determine the highlight, and column F (which may be hidden) contains the numeric values, calculated by the formula shown, that are compared with the value in the same row of column C to determine the colour to be applied to the number in that row, using the rule in the copy shown below.

To place the rules:

• Select the cells to be highlighted (C2-C8)
• Click the Format brush and chose Cell, then click the Conditional Highlighting bar at the bottom of the Format Inspector pane.
• with C2-C8 still selected, set the rules as shown.
• Numbers will automatically place those rules, adjusted for row, into all of the selected cells.

When setting the rules, you'll see these symbols:

Greater than is chosen from a list by clicking it.

Click the icon at the right end of the blue box, then click on the comparison cell (F2 in the example).

Choose the highlight action you want using the menu seen by clicking the down pointing arrow at the right.

Regards,

Barry