help with Conditional formatting pairs of cells

[Parish Pete]

I have a spreadsheet which is laid out as a burial ground map showing who is
buried where and whether a headstone is in place.

2 cells represent one grave as there may be 2 people buried there.

The format has 4 conditions:

Empty
used
used+memorial
reserved.

The sheet has 10 columns of around 20 pairs of cells.

Conditional format over the whole range works fine when the pair of cells
for a grave are marked empty or where both cells are used (for 2 people in a
grave).

My problem is finding an easy way to conditionally format the second cell of
each pair to match the first when the grave has only one occupant.

Presently where only one person is buried (shown in the first cell) the
second cell formats as empty as the rule dictates.

The columns are each separated by one blank column, all the cells in a
column are adjacent.

Any help welcome

regards

Pete

 

[Ando]

Have you tried an if statement?

I assume you are filling the burial ground map with names from master list
with vlookup and the conditional formatting trigger is text within the cell.

Can you include an if statement on the second cell of the grave that if
there is only 1 name to the grave to say “half†or similar, which would
trigger the used conditional formatting?

Ando