conditional formatting and variable range sizes

[Carl]

I'm putting together some code to create a spreadsheet from scratch to
monitor delivery dates for projects, and certain cells need to have
conditional formatting applied to them. So, some rows will contain dates of
expected delivery, and the cells below will contain actual delivery dates for
each element of the project, while going across, each column will identify
the activity due on that date, e.g.

Project Code Print Date Despatch Date Product Launch Date

A123 01/01/06 12/01/06 15/01/06
A123-01 02/01/06 11/01/06
A123-02 30/12/05
A123-02
B001 12/02/06 15/02/06 22/02/06
B001-01
B001-02

and so on. The problem I'm having is I want to have conditional formatting
on these cells so that the project level dates have the formula
Formula1:="=(COUNTBLANK(fixrange)=0,COUNTIF(fixrange,cell_condition)=0), and
<> 0, where fixrange is defined by
Set fixrange = Range(.Cells(sectionrow + 1, colval), .Cells(rowval,
colval)), sectionrow being the project row, rowval being the row of the last
element on that project, and colval being each column.
The problem is it doesn't work <G> Does anyone have any ideas please?