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 whol
row for that work order should have a yellow background. next time th
order is entered and its status is still "T", that row should be yello
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 th
fourth row and enter "C" for status, all rows associated with order
should be back to default, ie no background color.

Thank
 
Hi
goto conditional format and enter the following formula
=SUMPRODUCT(($A$1:$A$999=$A1)*($B$1:$B$999="C"))=0

HTH
Frank
 
Back
Top