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