Quote Originally Posted by JBeaucaire View Post
Any chance what you meant was:

A = Weeks
B = Due date (entered manually)
C = Start Date (formula needed)

In C2, try: =B2-(A2*7)

Highlight all three cells (or a bunch of rows to do this all at once) and activate the Conditional Formatting window. Use these parameters:

Condition1: Formula Is: =TODAY()>$B2
Format... Patterns... Yellow

NOTE: You don't actually have to enter today's date into a cell to use the date in a CF formula. You can just use the TODAY() function and it works the same.

Awesome! Thank's a lot.