Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: CF lower case only

  1. #1
    Board Regular
    Join Date
    Nov 2004
    Posts
    909
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default CF lower case only

    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 by lapta301; Jul 17th, 2017 at 03:42 AM.

  2. #2
    Board Regular
    Join Date
    Jan 2017
    Location
    Ukraine
    Posts
    206
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: CF lower case only

    hi
    I am not sure that it will be the easiest way, but you could try to use:

    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...

  3. #3
    Board Regular
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,324
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: CF lower case only

    =exact(a1,upper(a1))=false
    Neil

  4. #4
    Board Regular Teeroy's Avatar
    Join Date
    Nov 2012
    Location
    Sydney, Australia
    Posts
    2,233
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: CF lower case only

    Try the following as the conditional formatting formula (sample for cell A1):

    Code:
    =AND(CODE(A1)>96,CODE(A1)<123)

  5. #5
    Board Regular
    Join Date
    Sep 2016
    Posts
    1,123
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: CF lower case only

    Another one for CF :

    =CODE(A1)=CODE(LOWER(A1))

  6. #6
    Board Regular Teeroy's Avatar
    Join Date
    Nov 2012
    Location
    Sydney, Australia
    Posts
    2,233
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: CF lower case only

    Quote Originally Posted by footoo View Post
    Another one for CF :

    =CODE(A1)=CODE(LOWER(A1))
    This formula would evaluate True for symbols as well which the OP indicated he didn't want.

  7. #7
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    29,604
    Post Thanks / Like
    Mentioned
    13 Post(s)
    Tagged
    1 Thread(s)

    Default Re: CF lower case only

    Quote Originally Posted by Teeroy View Post
    Try the following as the conditional formatting formula (sample for cell A1):

    Code:
    =AND(CODE(A1)>96,CODE(A1)<123)
    This would also work...

    =ABS(109.5-CODE(A1))<13
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See here.

  8. #8
    Board Regular
    Join Date
    Nov 2004
    Posts
    909
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: CF lower case only

    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.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com