VBA code that you can use to highlight cells with a specific text in a worksheet in Excel.
VBA Code:
Sub HighlightCellsWithText()
Dim rng As Range
Dim cell As Range
Dim searchText As String
' Set the range as the entire worksheet
Set rng = ActiveSheet.UsedRange
' Set the text to search for (change "specific text" to your desired text)
searchText = "specific text"
' Loop through each cell in the range
For Each cell In rng
' Check if the cell contains the specified text
If InStr(1, cell.Value, searchText, vbTextCompare) > 0 Then
' Highlight the cell with a yellow color
cell.Interior.Color = RGB(255, 255, 0)
End If
Next cell
' Inform the user that the highlighting is complete
MsgBox "Cells with the specific text have been highlighted!"
End Sub
Join Our Telegram Group
Join Our WhatsApp Group
