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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I modify a row depending upon what a cell value is? (https://www.excelbanter.com/excel-worksheet-functions/5722-how-do-i-modify-row-depending-upon-what-cell-value.html)

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

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

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

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