Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Modify Row & Cell Contents based upon Cells Values
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want to format a cell based on an adjacent cells value | Excel Discussion (Misc queries) | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Modify Row & Cell based on Multiple Data | Excel Worksheet Functions | |||
Modify Row based upon cell value | Excel Worksheet Functions |