title: Excel VBA function to make a cell text 'BOLD' won't work
body: <pre><code>Public Function highlight_text(Search)
    Dim rng As Range
    Dim cell As Range
    Set rng = Range("A2:H32")
  
    For Each cell In rng
        If cell.text = Search Then
            cell.Font.ColorIndex = 3
            cell.Font.Name = "Arial"
            cell.Font.Size = 14
            cell.Font.Bold = True
        Else
            cell.Font.Bold = False
            cell.Font.Size = 11
            cell.Font.ColorIndex = 1
        End If
    Next cell
  End Function
  </code></pre>
  
  <p>The above function is called on 'mouseover' a cell, it manages to set the proper cells to RED color but it won't make the text bold</p>