conditional format whole row based on 2 rows
 

is it possible to format a whole row based on 2 cells with dates?
i would like to highlight the whole row if the second cell has already
gone beyond the date of the first cell.

for instance:
cell B1 has 2/1/07
cell B2 has 1/30/07
cell D1 has 2/3/07
cell D2 has 1/25/07

i want to be able to set a condition for the whole D column without
doing the tedious task of editing each row of D using Conditional
Formatting.

looking forward to everyone's reply.

conditional format whole row based on 2 rows
 

CF/ Formula Is: =$D1$B1
--
David Biddulph

"CTO" wrote in message
oups.com...
is it possible to format a whole row based on 2 cells with dates?
i would like to highlight the whole row if the second cell has already
gone beyond the date of the first cell.

for instance:
cell B1 has 2/1/07
cell B2 has 1/30/07
cell D1 has 2/3/07
cell D2 has 1/25/07

i want to be able to set a condition for the whole D column without
doing the tedious task of editing each row of D using Conditional
Formatting.

looking forward to everyone's reply.