ExcelBanter - How can I search for words in all caps in Excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I search for words in all caps in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/23015-re-how-can-i-search-words-all-caps-excel.html)

Nexan

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!

All times are GMT +1. The time now is 10:45 PM.