View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
papou papou is offline
external usenet poster
 
Posts: 110
Default Bold all rows where a cell contains text "X"

Hi
Please amend accordingly:

Sub PutInBoldXs()
Dim r As Range
With Range("A1:C10")
Set r = .Find("X", LookIn:=xlValues, searchorder:=xlByRows)
If Not r Is Nothing Then r.EntireRow.Font.Bold = True
End With
End Sub


HTH
Cordially
Pascal

a écrit dans le message de news:
...
I want to BOLD all rows where a cell contains text "X" in any cell in
range.

Does anyone has the solution?