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!
Bookmarks