2007 Conditional Formatting Column Graph

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
    68
    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
    1 Thread(s)

    Default Re: 2007 Conditional Formatting Column Graph

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

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
  •  

 

 
DMCA.com