Forum Discussion
Conditional Formatting - using multiple formulas
Hi guys, a little confused with the formulas in Conditional Formatting
I'm trying to highlight cells in Column B where it contains the model # i.e. the string in Column A, which contains both text and numbers
Column A is the model #
Coumn B is model # + suffix
Example, if this is the data, cells B1 & B2 should be selected.
A1 - ABC123
A2 - ABA123
A3 - ABB123
B1 - ABC1234 (this contains contents of A1)
B2 - ABB1235 (this contains contents of A3)
B3 - ABA1111
Thanks for your help in advance.
=NOT(ISERROR(MATCH(LEFT(B1,6),$A$1:$A$3,0)))
Select B1, set the conditional formatting to the above formula. After that, set the conditional formatting apply to $B$1:$B$3.
Hi Willy,
Thanks heaps for your response, but we require the formula to be more expanded beyond a 6 character model #, i.e. the model can be any length of characters, not just limited to 6.
(LEFT(B1,6)
Does that make sense?
yes, that make sense. I am sorry. how about the suffix? Is the suffix fixed length? if yes, you can change
LEFT(B1,6)
to
LEFT(B1,LEN(B1)-LEN(Suffix))
