How can I search for words in all caps in Excel?
Perfect. Thanks!
"Jason Morin" wrote:
Select your data and run this macro:
Sub OnlyUpper()
Dim cell As Range
For Each cell In Selection
If cell.Value = UCase(cell.Value) Then
cell.Font.ColorIndex = 3 'make font color = red
End If
Next
End Sub
---
HTH
Jason
Atlanta, GA
"Nexan" wrote:
As part of a macro, I'd like to be able to identify and re-format only cells
containing words in all caps. Is that doable?
Thanks!
|