Search on uppercase text

[Guest]

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!

 

[JE McGimpsey]

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

 

[vezerid]

You could also apply conditional formating.
Select all cells then, in Format|Conditional Formatting... Use
FormulaIs:
Supply the following formula:
=EXACT(A1, UPPER(A1))

HTH
Kostis Vezerides