Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I modify a row depending upon what a cell value is?
I am creating a database to help track packages for our front-desk. We LOVE
excel so I am trying to do it in excel. What I would like to have happen is this: When a user changes the "status" of a package from "Awaiting Pickup" to "Picked Up", the row needs to change to different color (like black or navy blue). I can't quite find a way to accomplish this. I have tried conditional formatting like this: =MOD(Row(), J2:J500)="Picked Up" and other variations but can't seem to get it. Any help would be greatly appreciated. Thanks. ~Brett Patterson |
#3
|
|||
|
|||
I have tried that, but am lost and can't find any help on M*crosoft's
website. That's why I came here. I was hoping someone could help me out. I just don't understand the language that MS is using for Excel, or what language it wants the formulas in. "Jim" wrote: try conditional formatting!~ -- Hope it Helps! Jim India "Brett Patterson" <Brett wrote in message ... I am creating a database to help track packages for our front-desk. We LOVE excel so I am trying to do it in excel. What I would like to have happen is this: When a user changes the "status" of a package from "Awaiting Pickup" to "Picked Up", the row needs to change to different color (like black or navy blue). I can't quite find a way to accomplish this. I have tried conditional formatting like this: =MOD(Row(), J2:J500)="Picked Up" and other variations but can't seem to get it. Any help would be greatly appreciated. Thanks. ~Brett Patterson |
#4
|
|||
|
|||
Select say A2 to Z100.
Then <Format <ConditionalFormat In the first box, select "Formula Is", and enter this formula in the right box: =$J2="Picked Up" then select your format, then <OK, <OK. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Brett Patterson" <Brett wrote in message ... I am creating a database to help track packages for our front-desk. We LOVE excel so I am trying to do it in excel. What I would like to have happen is this: When a user changes the "status" of a package from "Awaiting Pickup" to "Picked Up", the row needs to change to different color (like black or navy blue). I can't quite find a way to accomplish this. I have tried conditional formatting like this: =MOD(Row(), J2:J500)="Picked Up" and other variations but can't seem to get it. Any help would be greatly appreciated. Thanks. ~Brett Patterson |
#5
|
|||
|
|||
Thansk Rag. Works like a charm.
Now, is there a way that I can a cell and row based upon when a date is and the value of a cell? I want the status cell ($K2) to modify the first cell ($A2) and row if the date cell ($B2) is older than 14 days (14 days, not business days). Also, I want to insert a little graphic into the $A2 cell so that it is "flagged" as being old and needing delivery/update. Thanks for the help. ~Brett Patterson ================================================== === "RagDyer" wrote: Select say A2 to Z100. Then <Format <ConditionalFormat In the first box, select "Formula Is", and enter this formula in the right box: =$J2="Picked Up" then select your format, then <OK, <OK. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Brett Patterson" <Brett wrote in message ... I am creating a database to help track packages for our front-desk. We LOVE excel so I am trying to do it in excel. What I would like to have happen is this: When a user changes the "status" of a package from "Awaiting Pickup" to "Picked Up", the row needs to change to different color (like black or navy blue). I can't quite find a way to accomplish this. I have tried conditional formatting like this: =MOD(Row(), J2:J500)="Picked Up" and other variations but can't seem to get it. Any help would be greatly appreciated. Thanks. ~Brett Patterson |
#6
|
|||
|
|||
B2 has a date.
You want K2 to modify A2. What's in K2 and A2? And what do they have to do with B2 if B2 is supposed to control the formatting by being more then 14 days old? A full description of your set-up would get you more accurate suggestions. Don't forget, you know what you're talking about. We don't, and need a good verbal picture. -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "Brett m wrote in message ... Thansk Rag. Works like a charm. Now, is there a way that I can a cell and row based upon when a date is and the value of a cell? I want the status cell ($K2) to modify the first cell ($A2) and row if the date cell ($B2) is older than 14 days (14 days, not business days). Also, I want to insert a little graphic into the $A2 cell so that it is "flagged" as being old and needing delivery/update. Thanks for the help. ~Brett Patterson ================================================== === "RagDyer" wrote: Select say A2 to Z100. Then <Format <ConditionalFormat In the first box, select "Formula Is", and enter this formula in the right box: =$J2="Picked Up" then select your format, then <OK, <OK. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Brett Patterson" <Brett wrote in message ... I am creating a database to help track packages for our front-desk. We LOVE excel so I am trying to do it in excel. What I would like to have happen is this: When a user changes the "status" of a package from "Awaiting Pickup" to "Picked Up", the row needs to change to different color (like black or navy blue). I can't quite find a way to accomplish this. I have tried conditional formatting like this: =MOD(Row(), J2:J500)="Picked Up" and other variations but can't seem to get it. Any help would be greatly appreciated. Thanks. ~Brett Patterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
#REF! with cell value check | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |