Custom Formatting?
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Custom Formatting?

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    362
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I sometimes have to use a version of Excel which does not offer Conditional Formatting. However, i need to have the word "FEE" show as [Red] if entered into any cell within Column "A". (All other text will remain black).

    Anyone have any ideas? Can this be done with Custom Formatting?

    Thx.
    Noir

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Leiden, The Netherlands
    Posts
    68
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you're willing to do a small concession to the way you input the text, here's a suggestion.

    Give the cells in columna A a Custom format equal to:
    0;-0;[Red]"Fee"

    and input the word Fee as 0 (zero).

    Marc

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    362
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the suggestion Marc!

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    Place this in your Worksheet_Change()
    It will change red if fee is entered anywhere in column A

    Tom

    Dim Search
    Dim Found
    ActiveSheet.Columns("A:A").Font.ColorIndex = 0
    With ActiveSheet.Range("a1:a1000")
    Set Search = .Find("Fee", LookIn:=xlValues)
    If Not Search Is Nothing Then
    Found = Search.Address
    Do
    Search.Font.ColorIndex = 3
    Set Search = .FindNext(Search)
    Loop While Not Search Is Nothing And Search.Address <> Found
    End If
    End With

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    362
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks for the help Tom. It worked great!

    Noir

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