Alert in Microsoft Excel

[rayvn_]

Hello, helpful people.

I am not very familiar with Excel 2007, but I am gradually trying to become
familiar. I'll try to be clear with my complicated question.

In column A, I have a list of dates by which assignments are due. In column
B, I have a list of dates by which assignments were completed. I currently
have column B set up to change colors if a cell is blank (i.e., the cell is
orange until I enter a date).

Is there any way I can have column A alert me in some fashion if any cell in
column B remains blank when the date in column A comes to pass (in other
words, if the date in column A equals today's date).

Obviously the aim is to get the sheet to warn me if an assignment has not
been completed by its due date.

I appreciate any help you guys can give!

 

[Chip Pearson]

Use Conditional Formmating. Select your date cells. Open the CF
dialog, choose "Use Formula To Apply formatting" and use the following
formula:

=(AND(B1="",A1<=TODAY())

change the 1 in A1 and B1 to row number of the first selected cell.
Click the Format button to choose how you want the cell formatted if
the value in column B is empty and the value in A is today or earlier.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[rayvn_]

Chip,

Thank you so much for your prompt response. I tried your suggestion and got
a dialogue box in response that said I needed a parenthesis. I have pretty
good eyesight and saw many parentheses in your formula, so I'm not sure what
the program is asking me.

Just to be clear, when you wrote "select your date cells," you were
referring to the Assignment Due Date column and not the Assignment Completed
column, correct?

Ben