View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default 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