Hi people. I need some help. I have created a complaints sheet for work. Basically this is how the columns work:

A - Date of Call
B - Time of Call
C - Name of Customer
D - Address
E - Message
F - Date Passed On
G - Days Taken to Resolve.

At the moment I have conditional formatting on columns A and F, if it is more than 2 days for the complaint to be addressed then the cell in column F turns red, less then 2 days and it turns green. Column G pretty much works the same I just have F minus A.


MAIN PROBLEM:

My boss wants the following to occur. If there is a date in column A but no date in column F/blank cell after 2 days. (i.e. the complaint hasn't been resolved) the entire row should highlight red. I'm at my wits end trying figure out how to get this working but with no results, anyone got any ideas?


SIDE PROBLEM:

There is a complaints sheet for each month, is it possible for the sheets tab to highlight red if that month has passed and there are any outstanding complaints not resolved?