Conditional formatting for lowercase letters

[Milos]

Hi all,

I am trying to format a column so that I can identify when a cell contains lowercase letters and then I can change each cell to uppercase. The problem is that the cells change length and format down the list so I cannot use the =EXACT formula.

Example:[TABLE="class: grid, width: 400"]
<tbody>[TR]
[TD][/TD]
[TD]Topo Code[/TD]
[TD][/TD]
[TD][/TD]
[TD]Topo Code[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]AA123[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]AA123[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]p456[/TD]
[TD="align: center"]With conditional format applied[/TD]
[TD]2[/TD]
[TD]p456[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Ab789[/TD]
[TD="align: center"]==============>[/TD]
[TD]3[/TD]
[TD]Ab789[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]FF89[/TD]
[TD][/TD]
[TD]4[/TD]
[TD]FF89[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Gg09[/TD]
[TD][/TD]
[TD]5[/TD]
[TD]Gg09[/TD]
[/TR]
</tbody>[/TABLE]

Thanks team,

Milos

 

[FDibbins]

If you need to check and then change, why not just add a helper and make the change anyway?
=UPPER(B2)
will do the conversion to upper case for any letters. If needed, you can copy/paste values over the original data, then delete the helper

 

[JoeMo]

Why not change all cells to upper case?

Excel Workbook
	A	B
1	Initial	Upper
2	AA123	AA123
3	p456	P456
4	Ab789	AB789
5	FF89	FF89
6	Gg09	GG09
Sheet1

 

[Milos]

Thanks guys,

Yeah in normal circumstances I would definitely use that formula, however I am working with a quality assurance conditional format document that made. I copy/paste large data sets from a new database. I use this conditional format document to perform QA procedures on the data and then change it in the database (as we have little $$$ to update the new database currently).

Thus I need a code to work in a conditional format setting. When I enter the =UPPER(A1) rule into conditional formatting it does not seem to do anything. I tried that scenario first up.

 

[FDibbins]

If you really need to use CF for this...
=exact(A1,UPPER(A1))

 

[Tetra201]

Try this CF rule:

=NOT(EXACT(A1,UPPER(A1)))

 

[FDibbins]

If you really need to use CF for this...
=exact(A1,UPPER(A1))

oops that will highlight if it IS caps - thanks Tetra