change background color of row until condition is met

[fullymooned]

I have 2 columns, status and order. If the status is "T", then the whole
row for that work order should have a yellow background. next time the
order is entered and its status is still "T", that row should be yellow
too until the status for the order becomes "C"
when it bcomes "C", all the yellow rows should be back to default

A B
ORDER STATUS
1 T
2 C
1 T
1 C

So the first and third rows should be yellow, but when i enter the
fourth row and enter "C" for status, all rows associated with order 1
should be back to default, ie no background color.

Thanks

 

[Bob Phillips]

Answered in .misc. Please don't cross-post, multi-post if you want to hit
multiple groups.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Harlan Grove]

Answered in .misc. Please don't cross-post, multi-post if you want to hit
multiple groups.

Exactly backwards. Crossposting is OK because THAT means sending the SAME
message to MULTIPLE newsgroups AT THE SAME TIME - all newsgroups are included in
the Newsgroups tag in the message. Multiposting is BAD because THAT means
sending POSSIBLY the same message to POSSIBLY multiple newsgroups ONE NEWSGROUP
AT A TIME - each multiposted message has a single newsgroup in its Newsgroups
tag.

PLEASE GET YOUR TERMINOLOGY CORRECT!