CF lower case only

lapta301

Well-known Member
Joined
Nov 12, 2004
Messages
1,001
Office Version
  1. 365
Platform
  1. Windows
Hi

I have a range of cells that contain 1 character only and I want to highlight those where the character is lower case.

I have seen similar variations here but they don't seem to only limit it to lower case text.


As an example using these letters k J 7 q f & H ^ 5 P

I only want k q f to be coloured

As ever any help would be appreciated
 
Last edited:

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
hi
I am not sure that it will be the easiest way, but you could try to use:

Rich (BB code):
 If cell(i,j) = chr(102) or cell(i,j) = chr(107) or cell(i,j) = chr(113) then '102 - f,107 -k ,113 - q 
and so on...
 
Upvote 0
Try the following as the conditional formatting formula (sample for cell A1):

Code:
=AND(CODE(A1)>96,CODE(A1)<123)
 
Upvote 0
Another one for CF :

=CODE(A1)=CODE(LOWER(A1))
 
Upvote 0
Thank you all for showing an interest.

I can confirm with very grateful thanks that both Rick & Teeroy's responses seem to work perfectly.

Again my sincere thanks to you.
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top