Macro for Highlight cell with two condition

[vivamz]

Hi All,

Hope you guys are doing great !

I want Column B to highlighted in RED, If Column B is "iPhone" and Column C is "Used". I am attaching the sample file.

Please give me coding for this.

Thank you so much in advance.

 

[Marc L]

Hi,​

​

according to your attachment a VBA beginner starter demonstration to paste to the Sheet1 worksheet module :​

Sub Demo1()
           Dim Rg As Range, R&
        Application.ScreenUpdating = False
    With Me.UsedRange.Columns(2)
           .Font.ColorIndex = xlAutomatic
           Set Rg = .Find("iPhone")
        If Not Rg Is Nothing Then
                   R = Rg.Row
            Do
                    If Rg(1, 2).Value2 = "Used" Then Rg.Font.Color = vbRed
                   Set Rg = .FindNext(Rg)
            Loop Until Rg.Row = R
                   Set Rg = Nothing
        End If
    End With
        Application.ScreenUpdating = True
End Sub

Do you like it ? So thanks to click on bottom right Like !​

​

 

[vivamz]

Thank you so much Marc.

 

[vivamz]

Hi Marc,

I go an error "Invalid use of Me keyword".

Pls help

 

[Marc L]

As it rocks on my side, you just missed to well read my previous post, in particular the dark red direction !​

​

Tip for bad readers : replace Me keyword - a VBA help must see ! - with any other valid worksheet reference …​

​