VBA Code To Filter Data Based On First 2 Letters Of Word From Multiple Columns

[samsmith123]

Hi,

I am looking for a way to filter data based on the acronyms of two columns (SI_STRATIGRAPHY and SI_STRAND) from an excel spreadsheet. I need to be able to highlight data where the first two letters of SI_STRATIGRAPHY do not match the first two letters of SI_STRAND. Highlighted examples are shown in the screenshot attached.

Any help is much appreciated.

Kind Regards

[Keebellah]

Use conditional format to do this,
Since I do not have the data and am not going to type things I think you can manage.
Just select the entire range and add a new Conditional format rule using a formula that tests what you need and for true apply the desired format

[samsmith123]

Hi Keebellah, thanks for your response, still seem to be struggling with this. Any chance you could give an example of the formula that should be used with conditional formatting? There are two columns to compare data with about 20,000 rows of data.

[Keebellah]

Very simple.
For starters select the range A2 through K26

Then go to Conditional Format and new rule based on formula
The formula:

Please Login or Register  to view this content.

set the format and after pressing OK

Apply to ...

Please Login or Register  to view this content.

Notice that the formula only has a $ at the column NOT the row

Hope this helps