Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have several columns of numbers, and I want to highlight one of those with a background color.

I have created a single cell at the top of these columns, that for each column contains either a 1 (for highlight) or 0 (for normal).

Is it possible to create a custom formatting for the cells in each column that use the value from the top cell to determine if the formatting should take effect or not?

It seems that I can only create a custom format that uses the cell contents itself, not a different cell.

share|improve this question
Unfortunately I cannot use the tag "Numbers" as the tag "Number" already exists. In this case, "Numbers" is the product name, not "several numbers". – Lasse V. Karlsen Jun 27 '12 at 16:47
It's iwork-numbers, and questions about software shouldn't have the mac tag. Cheers! – slhck Jun 27 '12 at 17:07

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.