Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Oct 2005
    Posts
    599
    Thanks
    1
    Thanked 1 Time in 1 Post

    Conditionally format a single character (excel 2003)

    Hi all...I have a worksheet with zzVisitor in cell A3 (the zz is in front of Visitor for sorting purposes).......I have the formula =A3 in cell A10....this puts the word zzVisitor in cell A10 on 'Worksheet 2', for public viewing....I am trying to devise a conditional formatting formula for 'Worksheet 2!'A10 that will color the letters zz white, so that it is not visible......any ideas...I have tried LEN and CHAR and SEARCH (to isolate the letters ZZ and then color it white, but nothing is working...any ideas? Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditionally format a single character (excel 2003)

    It is not possible to format part of the result of a formula differently. You could use the formula

    =MID(A3,3,100)

    in cell A10 instead, where 100 is an arbitrary number larger than the length of the longest entry you expect.

Posting Permissions

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