Results 1 to 2 of 2

Conditional Formatting a gantt chart

Threaded View

akpaine41 Conditional Formatting a... 05-04-2023, 04:08 PM
etaf Re: Conditional Formatting a... 05-04-2023, 05:21 PM
  1. #1
    Registered User
    Join Date
    09-07-2011
    Location
    Temecula, CA
    MS-Off Ver
    Excel 365
    Posts
    6

    Conditional Formatting a gantt chart

    Hello all, I have a call out for help. I have a Gantt Chart that I have modified. I am trying to get some conditional formating done and need some help with the formulas. let me explan

    I have the conditional formatting highlighting the current week. All the purple are items that are in need of service and the dates of service.

    I would like the purple boxes to show up green IF there is the Letters "PM" in column D and on the same line as the purple blocks. Please let me know if you need any more clairification. I have attached some Pics. 1.png2.png
    Last edited by akpaine41; 05-04-2023 at 04:12 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Gantt Chart Conditional Formatting
    By tbrozovich in forum Excel General
    Replies: 11
    Last Post: 08-12-2024, 04:33 PM
  2. [SOLVED] Using conditional formatting in gantt chart
    By CHIPROCKETS in forum Excel General
    Replies: 33
    Last Post: 06-13-2023, 05:38 AM
  3. [SOLVED] Gantt Chart - Conditional Formatting
    By TheGlossy in forum Excel General
    Replies: 4
    Last Post: 03-08-2022, 04:35 PM
  4. Gantt chart conditional formatting?
    By Caitlin1234 in forum Excel General
    Replies: 1
    Last Post: 02-18-2022, 03:41 PM
  5. Gantt Chart Conditional formatting
    By jsneak in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-30-2015, 07:19 AM
  6. 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
  7. Gantt Chart with conditional formatting
    By douglasdale in forum Excel General
    Replies: 2
    Last Post: 06-28-2010, 11:24 AM

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