Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search on uppercase text
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search on uppercase text
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search on uppercase text
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dates and text | Excel Discussion (Misc queries) | |||
How do I search for specific text and sum the cell to the right? | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
How do I use VLOOKUP to search for text? | Excel Worksheet Functions | |||
How to change text in multiple cells from Uppercase to proper cas. | Excel Worksheet Functions |