Forum Discussion

Copper Contributor

Nov 28, 2017

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 t...

excel

Alex Hsu

Copper Contributor

Nov 29, 2017

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?

Willy Lau

Steel Contributor

Nov 29, 2017

yes, that make sense. I am sorry. how about the suffix? Is the suffix fixed length? if yes, you can change

LEFT(B1,6)

LEFT(B1,LEN(B1)-LEN(Suffix))

Alex Hsu
Copper Contributor
Nov 29, 2017
Hi Willy,

Thanks, the suffix is not a fixed length either, and usually is 3-5 characters long.
- Willy Lau
  Steel Contributor
  Nov 29, 2017
  model
  ABC1234
  ABC123
  
  item
  ABC12345
  
  Can tell me whether the item matches any of the model?
  - Alex Hsu
    Copper Contributor
    Nov 29, 2017
    Hi Willy yes it will match both of those model