help with Conditional formatting pairs of cells
in [Functions]
|
Prev: How do I reference a worksheet name through a formula?
Next: I have a file that is 4mb. Cleared all formating...still big
From: Parish Pete on 28 Jan 2010 10:41 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
From: Ando on 28 Jan 2010 23:16
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 |