View Single Post
 
Old 01-28-2022, 01:07 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

I suppose you mean "row2 is the template" ( not row 1)?
If so apply the following CF to C3:C5
Code:
=AND($B3="Company ",$C3<>$C$2)
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
Reply With Quote