samdawn88, Good afternoon.
You can use Conditional Formatting to colour your cells depending with some dates.
Suppose you cell date is A2
Formula --> =$A$2<=TODAY()
Formula --> =AND($A$2-TODAY()>0, $A$2-TODAY()<=30)
Formula --> =$A$2-TODAY()>30
For quick and effective help, save your spreadsheet to a free website, www.sendspace.com, and place the link here for download.
Seeing the layout of the worksheet will make it easier for all of us to help you in a more concrete way.
Belo Horizonte, MG - Brasil.