Thread
:
How do I modify a row depending upon what a cell value is?
View Single Post
#
3
Brett Patterson
Posts: n/a
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
Reply With Quote