Thread
:
Search on uppercase text
View Single Post
#
3
Posted to microsoft.public.excel.misc
vezerid
Posts: n/a
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 With Quote