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

Thread: 2007 Conditional Formatting Column Graph

  1. #1
    Board Regular
    Join Date
    Nov 2012
    Posts
    80
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question 2007 Conditional Formatting Column Graph

    Hello everyone!

    I have a dynamic chart. Simple column graph. That's all working as expected. Now what I would like to do, is to color the column red if the score for that week is below X-value. Let's say 85%.

    So, if the score for the week in cell B5:
    >=$B$5 Green
    <$B$5 Red

    How can I do that easily? I know it can be done rather easily, but I am overlooking something here.

    Any advice would be welcomed!

  2. #2
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    8 Thread(s)

    Default Re: 2007 Conditional Formatting Column Graph

    HTH, Peter
    Please test any code on a copy of your workbook.

Some videos you may like

User Tag List

Tags for this Thread

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
  •