I need to conditional format a whole row of data if Cell A contains/starts with A-BC and Cell B contains/starts with B-CD. If these (both) are not present then leave unhighlighted.
I have tried the formula's below:
Of which none work (which you've probably gathered!)
any suggestions would be massively welcome.