How to: Autocomplete

Dealing with medical billing reports. Is there a rule that I can set to autocomplete a certain cell if other cells have certain characters?   For Example: If any cell says "BCBS" and any cell in t...