Hello

In this spreadsheet we have pairs of columns for each week-ending date.
Let's say that week 1 uses Columns C&D. Each Row represents a store. Columns
C and D both represent week-ending 6th October 2007.

I need a formula which will look along the row and check for a blank. If
Column C is blank and there is a figure in Column D, or vice-versa, I want
the formula to flag this occurence. In other words, I want the spreadsheet to
show me where a store has enetered a figure in one column but no figure in
the paired column across the sheet.

Can anyone suggest a formula please?

Many thanks.

Keith