Hi,

I've been working on this for a couple of days and I'm not sure if Excel can do what I'm trying to make it do. Any help would be greatly appreciated. The problem is explained below.

Column A = Value (2 or 5 or 4 for example). I want excel to read this as a week. So for example A1 would have value 3 but excel would recognize it as 3 weeks.

Column B = Date (12/11/09 for example)

Column C = Due Date. So if A1 had 3, B1 had 12/11/09, C1 would automatically say C1 = 11/20/09 (3 weeks prior to 12/11/09).

Column D = Today's date. If Column D is a later date then Column C (So if it is 11/22/09) than the entire row automatically highlights (Conditional Format).

Thanks for all the help. I've trying for a while but to no avail.