change background color of row until condition is met

  • Thread starter Thread starter fullymooned
  • Start date Start date
F

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
 
IF I understand correctly, use Conditional Formatting. Select all rows, go
to CF (Format>Conditional Formatting) change Condition 1 to Formula Is, add
a formula of =SUMPRODUCT(($A$1:$A$100=$A1)*($B$1:$B$100="C"))=0, and set the
backrgound pattern colour to yellow

--

HTH

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