Hi Martin

Many thanks for that. It works a treat!

"MartinW" wrote:

Correction!!
Where I said formula painter, read format painter.


"MartinW" wrote in message
...
Hi Keith,

You will have to adjust this to suit, but I think it will do what you
want.

Select cell C2 and set Conditional Formatting
with Formula is =COUNTBLANK(C2:D2)=1
(pick a color)
Then
Select cell D2 and set Conditional Formatting
with Formula is =COUNTBLANK(C2:D2)=1
(pick same color)
(note same formula in each cell but applied seperately)

Now highlight both cells and use the formula painter
to drag them across the sheet.
Then reselect the entire row grab the formula painter
and once again select the entire row and drag down as
far as is needed.

It works in my trials here but you may need to adjust for your
data

HTH
Martin


"bollard" wrote in message
...
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