Ok, well first things first:

I will need to consolidate my conditionals, that's for sure.

I tested the DATEVALUE($b2) and got: #VALUE!

So, I found out that By using the following formula, it works to change
the row red:
=AND($K2="Awaiting Pickup", (TODAY()-14)$B2)

So, now all I need to do is figure this out:

I want to change the contents of the cell A in the row based upon the
preceding statement. *IF* both of the previous are true, I want the
value of column A in that row to become *[ ! ]*. I bet that there is a
way to condense the two into one function. I'm missing something, but
not sure what it is.

Any thoughts on how to do it? Also, this worksheet is 500 rows
multiplied over 11 sheets, so all of my formulas have to wrok based
upon any row, but the columns are identical.

Thanks for your continued help.

~Brett


--
bpat1434
------------------------------------------------------------------------
bpat1434's Profile: http://www.excelforum.com/member.php...o&userid=16155
View this thread: http://www.excelforum.com/showthread...hreadid=275903

Didn't this original suggestion work:

=IF(AND((TODAY()-14)$B2,$K2="Awaiting Pickup"),"[!]","")



bpat1434 wrote:

Ok, well first things first:

I will need to consolidate my conditionals, that's for sure.

I tested the DATEVALUE($b2) and got: #VALUE!

So, I found out that By using the following formula, it works to change
the row red:
=AND($K2="Awaiting Pickup", (TODAY()-14)$B2)

So, now all I need to do is figure this out:

I want to change the contents of the cell A in the row based upon the
preceding statement. *IF* both of the previous are true, I want the
value of column A in that row to become *[ ! ]*. I bet that there is a
way to condense the two into one function. I'm missing something, but
not sure what it is.

Any thoughts on how to do it? Also, this worksheet is 500 rows
multiplied over 11 sheets, so all of my formulas have to wrok based
upon any row, but the columns are identical.

Thanks for your continued help.

~Brett

--
bpat1434
------------------------------------------------------------------------
bpat1434's Profile: http://www.excelforum.com/member.php...o&userid=16155
View this thread: http://www.excelforum.com/showthread...hreadid=275903

--

Dave Peterson