conditional format whole row based on 2 rows

C

CTO

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formattion for whole row based on one cell value 3
Can you conditionally format a whole row based on data in one cel 1
Conditional Format Range of Cells 3
Copying conditional formating 2
Conditional Format in '07 1
Conditional formatting Entire Row Based on single Cell Value 5
Counting number of days up to an empty cell then start over again 1
How to use conditional formatting for rows, based on info in cells 2

Top