Microsoft 2007 Excel question =X (conditional formatting)

Discussion in 'Bing' started by itzCarlin, Dec 27, 2007.

0
  1. #1
    Hi, I am using microsoft excel 2007 and have a little question about conditional formatting. How do I set conditional formatting so that "if column a is greater than eight characters, change to this color" Anyone have any idea?
     
    itzCarlin, Dec 27, 2007 IP
  2. WebGodzilla

    WebGodzilla Peon

    Messages:
    32
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Seems like you have to write a short VB function like this:

    Function Length(val)
    val = CStr(val)
    Length = Len(val)
    End Function

    It must be placed in a module.
    Then you'll be able to use this function everywhere in Excel.
    Condition must be formula and you can type in the Length function there.
     
    WebGodzilla, Dec 27, 2007 IP
  3. itzCarlin

    itzCarlin Active Member

    Messages:
    849
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    60
    #3

    that went completely over my head o_o

    where do i place that VB function?
     
    itzCarlin, Dec 27, 2007 IP