LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default conditionally format pairs of cells in columns

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.
it's first 4 columns as a master list of grave numbers and against each
grave number is put 'M' for memorial if there is one, and the fore and
surname of the deceased. there are two lines per grave.

Each grave on the map (pair of cells) calls the info from the master list
and displays it on the map with the appropriate format.

The format has 4 conditions and does not have to differentiate between 1 or
2 people in a grave:

Empty (diagonal black lines)
used (no format is applied)
used+memorial (cyan fill)
reserved. (horizontal red lines)

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditionally Format Unlocked Cells Thomas M. Excel Discussion (Misc queries) 1 March 31st 09 11:06 PM
Can I conditionally format 1 cell to look at 5 cells DFRESH Excel Discussion (Misc queries) 2 February 19th 09 08:25 PM
Comparing pairs of cells in four columns brents18 Excel Discussion (Misc queries) 7 July 3rd 07 04:10 PM
How can I conditionally format cells that contain formulas? jhofmann Excel Discussion (Misc queries) 2 April 6th 06 04:04 PM
conditionally format cells elad Excel Worksheet Functions 2 May 13th 05 03:57 PM


All times are GMT +1. The time now is 04:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"