+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting bar charts based on value

  1. #1
    Registered User
    Join Date
    02-16-2015
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    64

    Conditional Formatting bar charts based on value

    Hi All,

    i would like to be able to use conditional formatting on my bar chart in excel based on cell value. So that if it is below the value it goes red, around the value it goes yellow and above it goes green.

    Can this be done?

    Would really appreciate the help,

    Thanks,

    Adam

    7.10.15.xlsx
    Last edited by Adamlee; 10-07-2015 at 08:39 AM.

  2. #2
    Registered User
    Join Date
    02-16-2015
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    64

    Re: Conditional Formatting bar charts based on value

    Reuploaded with updates

  3. #3
    Registered User
    Join Date
    02-16-2015
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    64

    Re: Conditional Formatting bar charts based on value

    Can Anyone help????

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Conditional Formatting for Charts
    By benjthom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-31-2013, 12:06 AM
  2. Charts and Conditional Formatting
    By swatkins1977 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-07-2012, 10:43 AM
  3. Conditional formatting on bar charts
    By cosmo6 in forum Excel General
    Replies: 1
    Last Post: 02-25-2009, 07:05 AM
  4. Conditional Formatting on Bar Charts
    By Paul Sheppard in forum Excel General
    Replies: 2
    Last Post: 06-30-2008, 04:03 AM
  5. Conditional formatting of charts.
    By SER01 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 11-04-2007, 08:36 PM
  6. [SOLVED] conditional formatting in charts
    By Dan_Green in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-01-2006, 09:15 AM
  7. [SOLVED] Conditional formatting in Charts?
    By Todd in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-11-2005, 03:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1