Conditional highlighting

Question

Level 1

4 points

Conditional highlighting

I’m new to everything involved with numbers but I know something like this that exists in excel so I thought I could do it here too.

In page 1 there’s a label, where I’ll be writing names. In page 2 I’ll have a label full of those names and some different ones.

If a name from the label of page 2 is written in the label of page 1, I want that name (from page 2) to be crossed or to change color to red.

I managed to do this thing but only on one cell, and I couldn’t find a way to involve all the other cells of page 1.. other than creating a new rule for the 199 remaining cells.

I also tried selecting a whole row/column of page 1 instead of a single cell, but unless the entire row/column had the same name in it equal to the one written in the label 2, it wouldn’t work

Windows, Windows 6

Posted on Jul 23, 2022 12:33 PM

Reply

Answer 1

Badunit

Level 7

30,540 points

Jul 23, 2022 6:11 PM in response to Andri58

In Numbers, conditional highlighting of a cell is based on the contents of the cell itself or comparison with the contents of another cell. For example, you can create a rule that says "if the text in the cell is 'hello' then use red text". Or you can create a rule that says "if the text is the same as in cell B4 then use red text".

For a problem like yours, you need to do a comparison, but it can only be to a single cell not an entire column of names. You can add a new column to Table 1 that looks for the name in Table 2 and, if found, puts that name in the cell. Then you can compare to each of those cells. Below is an example.

The formula in the cells of column B =XLOOKUP(A,Table 2::A,Table 2::A,"",0)

To create the highlighting rule:

Select column A, all but the header row. In this example it is A2 through A10
In the format sidebar, cell tab, click on Conditional Highlighting
Add a rule for "text is"
In the box where you would type some text, click on the green oval instead.
Click on cell B2. The result is that A2 will look at B2, A3 will look at B3, etc.
Choose the format to be red text

Hide column B

Reply

Conditional highlighting

Similar questions