Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Format cell contents depending on value of functio (2000)

    I know we have addressed this topic before, but can someone tell me if there is a way to format the color of the font of a call, depeding on the function results of the cell? For example, if the cell contains a sum function, is there a way to tell the cell to display Red if the sum is less than zero, and Green if the sum is greater than zero? If this isn't possible, someone should tell the folks at Microsoft this would be, IMHO, a good feature!

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Format cell contents depending on value of functio (2000)

    Does this post <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=39851&page=&view= &sb=&o=&vc=1>here</A> help?

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Format cell contents depending on value of functio (2000)

    Yes-Thanks a bunch!
    Jeff

Posting Permissions

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