I suppose you mean "row2 is the template" ( not row 1)?


If so apply the following CF to C3:C5 Do the same for each other column, keeping the =AND($B3="Company " part and adapt the second condition to the new column, like $D3<>$D$2
Be careful with the relative and absolute addressing and adding the trailing space behind "Company "

Can it be done in one go? I don't think so

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post