Copy the conditional highlighting to other sheets

Hi Hans,

A bit of Numbers vocabulary to start. Using vocabulary specific to Numbers can avoid misunderstandings when asking future questions.

Spreadsheet, Document, or Spreadsheet document refer to the whole document saved in a File.

The Document consists of at least one Sheet, but can have additional Sheets.

When created, a Sheet contains one Table, by default named Table 1. Other Tables may be added to the Sheet, as may other objects such as Text boxes, Shapes, Charts and Images.

Each Sheet has a name, displayed in a Tab. The name may be edited by the user.

Tables are composed of Cells, arranged in Columns and Rows. Each Table has a name, which may be edited by the user.

Conditional Highlighting rules are applied to Cells, and are part of the Format settings for that cell.

The Format settings of a Cell may be copied, and pasted to other cells.

The 'other cells' may be on the same Table or on another Table.

The 'other Table' may be on the same Sheet or on another Sheet.

The 'other Sheet' may be in the same 'Document' or in another Document.

To Copy the format settings of a cell, including conditional rules:

• Click once on the cell to select it.
• Go Format (menu) > Copy Style (or press option-command-C)

To Paste the copied format settings to another cell (or group of cells)

• Select the cell(s)
• Go Format > Paste Style (or press option-command-V

Regards,

Barry

Hi Hans,

You could, but if all cells in the column have the same set of rules, your better action is probbly to copy the format of a single cell, then select the entire column to which you want those rules to apply (this can be a column in the same table, a different table on the same sheet, a different table on a different sheet in the same document, or a different table on a different sheet in a different document from the original), then paste.

One limitation might be that the comparison must be with a fixed value, written into the rule. Rules which compare the value in a cell with the value in another cell are likely to produce a #REF error when transferred to another table. If pasted to a single cell, the error should be easy tor correct. once corrected, that cell's format may be copied, then pasted to the whole column.

Regards,

Barry

select the cell with the formatting, copy

select the detention cells, paste

if you do not want a particular date in the destination cell(s), delete the date before copying