Possible Duplicate:
Formatting a column based on another columns cell TEXT (not value) in Excel
How can I implement the following as an Excel formula?
If column j="renew" or "-" AND the date in column M is 4 days or more behind today's date,
then higlight or change color or whatever in column M.