Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Modify Row & Cell Contents based upon Cells Values
Unfortunately not. It wouldn't do anything to the row or cell value. Here's what I did to add that conditional format as I may have done something wrong: I selected the cell A2 and dragged my mouse to select the rest of the sheet at L500. I did Format|Conditional Formatting... Formula Is: =IF(AND((TODAY()-14)$B2,$K2="Awaiting Pickup"),"[!]","") After inputting 10/1/2004 as the date, and the status as Awaiting Pickup, the row does nothing. If I change the status to "Picked Up" the row changes to a blue color (as expected). The =IF() is the second conditional statement. If I change it to just the AND statement, the row changes to red (like I want) but I can't make the cell $A2 change contents to be *[ ! ]* There's something in the If Statement. Any ideas? I was thinking perhaps there's a way I can do it with macros to modify the entire sheet.... perhaps? I attached my worksheet, so if you can figure it out, please let me know. ~Brett +-------------------------------------------------------------------+ |Filename: Front Desk Package Trackers.zip | |Download: http://www.excelforum.com/attachment.php?postid=2758 | +-------------------------------------------------------------------+ -- bpat1434 ------------------------------------------------------------------------ bpat1434's Profile: http://www.excelforum.com/member.php...o&userid=16155 View this thread: http://www.excelforum.com/showthread...hreadid=275903 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
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 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 |