Results 1 to 2 of 2

2007 Conditional Formatting Column Graph

This is a discussion on 2007 Conditional Formatting Column Graph within the Excel Questions forums, part of the Question Forums category; Hello everyone! I have a dynamic chart. Simple column graph. That's all working as expected. Now what I would like ...

  1. #1
    Board Regular
    Join Date
    Nov 2012
    Posts
    68

    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
    VoG
    VoG is offline
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651

    Default Re: 2007 Conditional Formatting Column Graph

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

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