Highlight Rows if Values(dates) in one cell is greater than values(dates) in another Cell

[confusedintern]

Hello,
I want to highlight rows if the dates in one cell is greater than dates in another cell..
For example, in the table below.. the items are supposed to get there by the dates in column B but they will be getting there by column D. So I want to highlight the rows(not just cell) if which this is the case. I have hundreds of columns like that and I don't want to spend my day doing it one by one.
Shoes 8/30/2016 50 8/31/2016
Flowers 9/1/2016 11 10/31/2016
Blouse 9/8/2016 5 8/31/2016
Pants 9/8/2016 3 9/30/2016
Earrings 9/15/2016 5 12/31/2016
Rings 9/15/2016 6 12/31/2016

Thanks!

[bebo021999]

What exactly is the row need to be highlighted? it is more clearer with a sample WS with before and after output

[davesexcel]

Hundreds of columns or hundreds of rows?

[ELeGault]

Yea slightly confusing but without knowing what you are trying to acheive... When we want ranges to highlight based on evaluation in a specific column your validation formula would look something like this

=$D1<$B1
Notice that ONLY the COLUMN is LOCKED in the formula allowing Excel to evaluate each line in the applied area!
Edited the above to meet your requirements in your last post

Your applied Range would be
=$A$1:$D$6
Notice that everything is locked in the applied Range... The 6 should the last row of the area in which you wish to apply. If your data goes beyond D then it should also change to that column.

Without knowing more about what you want we cannot offer a direct solution, but this explains how you would get a row to highlight and not just one cell...comes down to what you make "Ab$olute"

Cheers -
ELeGault

[davesexcel]

Possibly, change range as required

Please Login or Register  to view this content.

[confusedintern]

Before:

Shoes 8/30/2016 50 8/29/2016
Flowers 9/1/2016 11 10/31/2016
Blouse 9/8/2016 5 8/31/2016
Pants 9/8/2016 3 9/30/2016
Earrings 9/15/2016 5 12/31/2016
Rings 9/15/2016 6 12/31/2016


After:
Shoes 8/30/2016 50 8/29/2016
Flowers 9/1/2016 11 10/31/2016
Blouse 9/8/2016 5 8/31/2016
Pants 9/8/2016 3 9/30/2016
Earrings 9/15/2016 5 12/31/2016
Rings 9/15/2016 6 12/31/2016

I want to highlight each rows where the item will be shipped late. Dates in Column D are supposed to be earlier than dates in Column B, but if the dates in Column D are past dates in Column B.. I want the whole rows highlighted.

[ELeGault]

@ConfusedIntern

Please read both solutions offered as they both will meet this requirement if applied with a slight adjustment.

Please attempt to put them in to effect and then post the worksheet that is not working so that we can show you where you go wrong.

It does not make sense for us to create solutions if you are not willing to attempt to apply them -

Attempt>Share your work (POST THE FILE) and then we will get this resolved for you!

Cheers

[confusedintern]

I will attempt them but I just wanted to answer people's questions first.