Conditional formatting for lowercase letters

Milos

Board Regular
Joined
Aug 28, 2016
Messages
103
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 CodeTopo Code
1AA1231AA123
2p456With conditional format applied2p456
3Ab789==============>3Ab789
4FF894FF89
5Gg095Gg09

<tbody>
</tbody>

Thanks team,

Milos
 

FDibbins

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
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

MrExcel MVP
Joined
May 26, 2009
Messages
16,663
Why not change all cells to upper case?
Excel Workbook
AB
1InitialUpper
2AA123
3p456P456
4Ab789AB789
5FF89FF89
6Gg09GG09
Sheet1
 

Milos

Board Regular
Joined
Aug 28, 2016
Messages
103
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

Well-known Member
Joined
Feb 16, 2013
Messages
6,723
If you really need to use CF for this...
=exact(A1,UPPER(A1))
 

Forum statistics

Threads
1,081,415
Messages
5,358,533
Members
400,502
Latest member
price83

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top