Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Conditional Formatting leaves "TRUE" in the cells

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Toronto
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I tried the "Create a Gantt Chart" from the Tip of the Week. I get the selected color OK but I also get "TRUE" text in every colored cell. What am I doing wrong?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Are you entering the conditional formula directly into the worksheet cell? Or, are you using the Format | Conditional Formatting... menu command?

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Toronto
    Posts
    75
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm entering the formula directly into the upper left cell of the Gantt Chart area, just as directed by Mr Excel's Tip of the Week

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    I now have two examples of Gantt Charts
    a that is as 'Chart'
    and one that is an extention of the Tip of the Week.

    If you want I can send them to you.
    "Have a good time......all the time"
    Ian Mac

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Wayne,

    you need to select the upper left cell, you're okay so far, but don't actually enter the formula in it : you need to then enter the formula via conditional format :

    so :

    format (from the toolbar)
    conditional formatting
    change "cell value is" to "formula is"
    and follow the tip-'o-the-week

    [if this is where you were going wrong, I'm intrigued to find out how you got the colouring right though, ya got me there]


    :: Pharma Z - Family drugstore ::

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Wayne,

    I tried sending you the files but it came back as message box full on my system report, I know mine isn't full!!
    "Have a good time......all the time"
    Ian Mac

Some videos you may like

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
  •