B
bpat1434
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 don
something wrong:
I selected the cell A2 and dragged my mouse to select the rest of th
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 Awaitin
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 secon
conditional statement.
If I change it to just the AND statement, the row changes to red (lik
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 modif
the entire sheet.... perhaps?
I attached my worksheet, so if you can figure it out, please let m
know.
~Bret
+-------------------------------------------------------------------
|Filename: Front Desk Package Trackers.zip
|Download: http://www.excelforum.com/attachment.php?postid=2758
+-------------------------------------------------------------------
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 don
something wrong:
I selected the cell A2 and dragged my mouse to select the rest of th
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 Awaitin
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 secon
conditional statement.
If I change it to just the AND statement, the row changes to red (lik
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 modif
the entire sheet.... perhaps?
I attached my worksheet, so if you can figure it out, please let m
know.
~Bret
+-------------------------------------------------------------------
|Filename: Front Desk Package Trackers.zip
|Download: http://www.excelforum.com/attachment.php?postid=2758
+-------------------------------------------------------------------