Excel 2003, is there a way of identifying cells which have lower case by using a formula?

WE run a new report into Excel 2003 that shows each of the records for a given time frame.I desire to find cells who have lower case as I would like to identify them and get the users to prevent using lowercase from a field which i cannot confirm by tip.

try this

=EXACT(A1, UPPER(A1))

A system isn’t really going to do what you intend to do.Opertation handler may identify just about all cells containing lower instance text simply by filling the actual cell using color.

Copy this event handler to the clipboard:

Personal Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Targeted As Range)
ActiveSheet.Cells.Interior.ColorIndex = lnone
For every cell Around ActiveSheet.UsedRange
In case cell.Valuation = LCase(cell.Value) Plus _
mobile phone.Value “” Then
mobile phone.Interior.ColorIndex = 33
Stop If
Next
Stop Sub

Hit ALT + F11

Double click ‘This Workbook’ while in the Microsoft Excel Objects from the upper quit quadrant.

Paste the actual code into the editing area to the right.

Close this VBE and come back to the workbook.

Select a cell and also all ‘lower case’ cells might be highlighted.