Conditional Format Based on two individual letters within a text string

**T.Turner** · 01-13-2022, 01:12 PM

Hi

I'm trying to format a cell a certain colour if the cell above it contains the letters IN as the 5th and 6th digit within the string

Not having much joy, any help would be gratefully received

**BMV** · 01-13-2022, 01:15 PM

Formula:

Please Login or Register  to view this content.

**T.Turner** · 01-13-2022, 01:16 PM

thank you

Conditional Format Based on two individual letters within a text string

LinkBack

Thread Tools

Rate This Thread

Display

Conditional Format Based on two individual letters within a text string

Re: Conditional Format Based on two individual letters within a text string

Re: Conditional Format Based on two individual letters within a text string

Thread Information

Users Browsing this Thread

Similar Threads

Conditional format with text string containing numbers greater than a specific value

Conditional Format a Calendar based on Date Values and Text String

[SOLVED] Check letters in text string - conditional formatting

[SOLVED] Conditionally format based on a formula matching a string with digits, not letters

[SOLVED] Conditional Format Based on Matching or Not of First 3 Letters of another Column

Conditional format: mark cells with 1 text string & exclude cells with another string

Conditional Format based on Text String

Bookmarks

Bookmarks

Posting Permissions