You need conditional formatting.

Select the cell to format, and let's assume that the compare cell is A1
Menu FormatConditional Formatting
Change Condition1 to Formula Is
Add a formula of =AND(A1<TODAY(),B1="")
Click Format
Choose the text colour
OK
OK

--
HTH

Bob Phillips

"cebubum" wrote in message
...
I want to compare a date in a cell to the current date. If the current
date
is past the date in the specified cell, and the adjacent cell is blank, I
want the specified date to display in red. Would someone be so kind as to
assist me with this please.