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:

	Topo Code			Topo Code
1	AA123		1	AA123
2	p456	With conditional format applied	2	p456
3	Ab789	==============>	3	Ab789
4	FF89		4	FF89
5	Gg09		5	Gg09

<tbody>
</tbody>

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