Cond. formatting based on row above

[ThatOneDude]

I have conditional formatting set up that essentially says "if the status is Active, make the text in that row orange." and another rule that says "if the status is Discontinued, make the text in that row red."

In the example below, the external model represents multiple internal models so I need all the rows underneath to have the same formatting. Basically, I need a conditional formatting rule that says "if the status column is empty, match the formatting of the last row above it where the status column isn't empty." I need the black rows under the orange row to be orange and I need the black rows under the red row to be red, etc.

Is this possible?

 

[Joe4]

Assuming your data above is in the range A1:C9, select range A2:A9 and enter the following two conditional formatting rules via formula.

Rule 1/Formula 1:

=INDEX($B$2:$B$9,MATCH(LEFT($C2,FIND("-",$C2)-1)&"*",$A$2:$A$9,0))="Active"

and choose your orange font color

Rule 2/Formula 2:

=INDEX($B$2:$B$9,MATCH(LEFT($C2,FIND("-",$C2)-1)&"*",$A$2:$A$9,0))="Discontinued"

and choose your red font color

Results: