How do I modify a row depending upon what a cell value is?

[Brett Patterson]

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

 

[Jim]

try conditional formatting!~

 

[Brett Patterson]

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.

 

[RagDyer]

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!
==============================================


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

 

[Brett Patterson]

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]

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!
-------------------------------------------------------------------



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
=====================================================