One way, using a macro:
Public Sub BoldUpperCaseText()
Dim rTextCells As Range
Dim rCell As Range
On Error Resume Next 'in case no text constants
Set rTextCells = ActiveSheet.Cells.SpecialCells( _
xlCellTypeConstants, xlTextValues)
On Error GoTo 0
If Not rTextCells Is Nothing Then
For Each rCell In rTextCells
With rCell
If .Value = UCase(.Text) Then .Font.Bold = True
End With
Next rCell
End If
End Sub
If you're not familiar with macros, see
http://www.mvps.org/dmcritchie/excel/getstarted.htm
In article ,
Nadiya wrote:
Hello ~ formatting a very large spreadsheet - i need to search on text that
is in uppercase - and then bold that text. How do i search on that? Thanks!