You can do this using conditional formatting.

Let's assume A1:A10 = dates, B1:B10 = X or empty

Select the range of cells A1:B10
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=AND(TODAY()-30$A1,$B1<"X")
Click the Format button
Select the Patterns tab and pick the fill color of your choice
OK out

--
Biff
Microsoft Excel MVP


"Denise" wrote in message
...
Should I post this as a new question even though it concerns the same
project?

Is there any way to use the Date variable to change the color of an entire
row if 30-days have past and there isn't an "x" in my control column?
Basically if all of their items have not been turned in before a certain
time...we will find a more obvious flag like a gray background for that
employee's row?



"T. Valko" wrote:

Try this:

=IF(COUNTA(E2:I2),"","X")

--
Biff
Microsoft Excel MVP


"Denise" wrote in message
...
I am working on a spreadsheet that I created to audit employee files. If
their file is missing something (physical, background check, etc..) I
need
a
visual flag. Usually the items trickle in and I delete my comments in
the
column one-by-one. So I am trying to create a formula that places an
"x"
in
column D after all items are received. Any advice is appreciated.
Thank
you!