Complex Conditional Formatting Problem

Hello,

I have tried to solve this problem by reading these forums, as well as Microsoft's online resources, but I have not found a solution that works. I need each row to fill with red whenever the current date is greater than the expired date. I am currently using a macro to add the storage date each time something is entered into a cell in the Contents List (column D).

At best, I can get the storage and expired date to be filled with red, or some combination of cells get highlighted, but not the entire row.

Please help explain what needs to be done and/or provide a solution I can learn from.

Your help is greatly appreciated.