1. I need a my cells containing dates to highlight red when the current date
passes the date within the cell (basically I need to know when things are
behind).

2. How do I copy a conditional format from one cell and have it apply to a
different one (basically I want to do a series). I've even tried using the
special paste tool and selected formating and it still applies to the
original cell and not the new one(ie: format 1 =R5C7 and when copied to row
7, column 7 it will still format to =R5C7 instead of =R7C7). There are no $
in the formula to be removed so it will do a series (I read this in someone
else's post). How can I do this?