Conditional Formatting one date less than other.

[Lensmeister]

I am stumbling today badly Sorry for these dumb questions.

In column D I have a date (different on each row) and in Column E I have another date (again different dates on different rows)

I need Column D conditional formatted to that

If the date in column D is less than Column E then it turns red.

I tried doing one row and it was giving erroneous formatting

Can someone just give me an idea how to do this please ... Need a lot of rows done.

Thanks

 

[Minty]

You need to type in a expression in the conditional format dialogue something like

[Column D] < [Column E]

Where the square brackets contain your field names.

 

[Lensmeister]

Thanks

That got me thinking straighter

 

[arnelgp]

select all cells in column d.
on the ribbon home->conditional formatting->new rules->use formula to determine which cells to format.
Format values where this formal is true (box) write:
=$d1 < $e1
Click format and choose what color to display
click Ok.