0
I need help with conditional formatting.
I have a VBA code to compare two columns, one that is in a hidden tab, contains a series of systems that we use in the company and another one contains a column where these systems are mentioned, but in this second column the systems may be accompanied with additional information and so this 'validation' does not work since the values are not exact.
E.g.:
Column A
HANA_ERA
Column B ASIA-HANA_ERA-PRODUCTION
Do you have any hint of what I could add to the code below for this validation to occur and conditional formatting to work?
Sub Sistemas_Criticos()
'
'
'
Dim rng As Range
Application.ScreenUpdating = False
Sheets("_db").Visible = True
Sheets("_db").Select
With Worksheets()
Sheets("_db").Range("a2", Sheets("_db").Range("a2").End(xlDown)).Select
End With
Sheets("e-Template").Select
With Worksheets()
ActiveSheet.Range("f8", ActiveSheet.Range("f8").End(xlDown)).Select
End With
Selection.FormatConditions.AddUniqueValues
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
Selection.FormatConditions.DupeUnique = xlDuplicate
With Selection.FormatConditions.Font
.Bold = True
.Italic = False
.Underline = xlUnderlineStyleNone
.Color = -16776961
.TintAndShade = 0
End With
Selection.FormatConditions.StopIfTrue = False
Sheets("_db").Visible = False
End Sub
Thanks in advance for your comments and suggestions.
See the function Urge or conditional with Like operator
– danieltakeshi
I took a look and I think it’s not exactly what I’m looking for. Is there something like 'contains' where I can declare a column?
– rdshibuya
See if this answer help you
– danieltakeshi