Modify Row & Cell Contents based upon Cells Values

[bpat1434]

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 chang
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 th
preceding statement. *IF* both of the previous are true, I want th
value of column A in that row to become *[ ! ]*. I bet that there is
way to condense the two into one function. I'm missing something, bu
not sure what it is.

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

Thanks for your continued help.

~Bret

 

[Dave Peterson]

Didn't this original suggestion work:

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

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