+ Reply to Thread
Results 1 to 1 of 1

Gantt chart (conditional formatting not responding)

  1. #1
    Forum Contributor
    Join Date
    01-06-2015
    Location
    london,uk
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2307) 64-bit....Windows 10 Enterprise
    Posts
    118

    Gantt chart (conditional formatting not responding)

    Hi,

    Could you please assist with the attached.

    Issue:

    - Some of the bars are not responding to changes made in column H and K (timescales) as they should. For example, row 15's bar chart is incorrect whilst row 16 works. Row 15 shows 1-20 june rather than 1-14 june. The errors are consistently taking place everywhere.



    Notes:

    - Please do not delete the blank rows (column C) or change the WBS level or WBS.
    - I prefer the workbook simpler hence why some columns are hidden. I prefer manually inserting the dates but I would like the bar graphs on the right to work.

    Thanks
    Chris
    Last edited by chris1089; 07-02-2021 at 05:02 AM.

+ 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. [SOLVED] Conditional Formatting w/ Gantt Chart
    By ormont02 in forum Excel General
    Replies: 10
    Last Post: 02-24-2019, 11:55 PM
  2. Gantt chart in hours using conditional formatting
    By Zimboes in forum Excel General
    Replies: 4
    Last Post: 05-20-2016, 11:10 AM
  3. Gantt Chart Conditional formatting
    By jsneak in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-30-2015, 07:19 AM
  4. Gantt Chart Conditional Formatting
    By tbrozovich in forum Excel General
    Replies: 6
    Last Post: 06-25-2015, 02:23 PM
  5. Conditional formatting to measure actual vs planned Gantt chart
    By arnab0711 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-19-2015, 04:19 PM
  6. Gantt Chart with conditional formatting
    By douglasdale in forum Excel General
    Replies: 2
    Last Post: 06-28-2010, 11:24 AM
  7. Conditional formatting gantt chart help needed
    By kelly3000 in forum Excel General
    Replies: 2
    Last Post: 01-05-2010, 08:00 AM

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