Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Oct 2005
    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
    Thanked 28 Times in 28 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


    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