Excel 2007 : Conditionally Highlight blank cells in column subject to condition in another column

Hi,

I want to conditionally highlight (in red) the blank cells in one column (the Date received column) that also meet a date condition in another column (the Transfer Date column). I also highlight all the corresponding account balances (in the Account Balances column) for the accounts that were just highlighted.

I attached an illustrative workbook. the first tab has the raw information. The second tab contains two pieces of analytical information, which you can ignore, but it might help you with the conditional formula. This post thread from earlier today might also be helpful (http://www.excelforum.com/excel-2007...er-column.html).

I want to highlight the cells in the Transfer Date column for accounts that were received more than 120 days ago and for which there is no tranfer date entered. Then I also want to highlight the corresponding balances.

Thanks. God Bless You.

Highlight C2:C12
Enter this CF formula: =AND($C2="",TODAY()-120>$A2)

Just add another AND statement to watch that column:

=AND($A2<>"", $C2="", TODAY()-120>$A2)