Conditional Formatting and the IF statement

I've got a simple family budget sheet and I want to track when bills are paid and by how much. Conditional formatting makes the results stand out.

So, if I have a sheet that looks like this:

Bills Amount Paid Amt. Due Date Date Paid
Bill X $100.00 $100.00 5/15/2016 5/16/2016
Bill Y $200.00 $100.00 5/18/2016 5/16/2016
Bill Z $300.00 $100.00 5/8/2016 5/16/2016


OK, it doesn't line up too well here, but I hope you get the idea. The Paid Amt. column should be blank at this point.

I want to highlight in red if a bill isn't paid, or if I've paid it past its due date, or if I've paid less than the full amount. Similarly, I want to highlight in green if the bill has been paid, if it's paid on time, or if I've paid it in full.

Ready? Go!

Try this
Format Conditional with the formula
=D2<E2 and apply this to $C$2:$C$4