how do I highlight rows with a certain phrase? [cl

Question

Closed. This question is off-topic. It is not currently accepting answers.

---

Want to improve this question? Update the question so it's on-topic for Stack Overflow.

Closed 6 years ago.

The place I work for has monthly numbers listed in an Excel spreadsheet. Every month my coworker has to find every row with the phrase Jacobs Eng QP and highlight the row manually. Is there a macro that could do this for me?

Answer 1

have you tried HOME->Conditional formatting -> Highlight Cell Rules -> Text that contains ?

Answer 2

Select range

Click Conditional Formatting in the ribbon.

then Equal to and type Jacobs Eng QP in the input box.

---

VBA user-friendly solution

Option Explicit

Sub HighlightCells()

    Dim rangeToCheck As Range
    Set rangeToCheck = Application.InputBox(Prompt:="Please Select Range", Title:="Range Select", Type:=8)

    Dim searchTerm As String
    searchTerm = InputBox("Enter search term")

    Dim cell As Range
    For Each cell In rangeToCheck
        If InStr(1, cell, searchTerm, vbTextCompare) Then cell.Interior.Color = RGB(255, 0, 0)
    Next

End Sub

Additional resource:

• Highlight cells based on a condition

Answer 3

I would use custom formatting combined with a formula like INSTR() - I cannot guide you because my office Version uses totally diffferent keywords ( I love the translation of office...)