Forum Discussion

Iain_KNox's avatar
Iain_KNox
Copper Contributor
Jun 16, 2022

Conditional Formatting gantt which has a weekly column header

Hi, I have a gantt chart which I've set to conditional format cells which have a start and end date.  The time range for the gantt is set up weekly.  However,  if a milestone or activity is less than...
excel
Martin_Weiss's avatar
Martin_Weiss
Bronze Contributor
Jun 20, 2022

Hi Iain_KNox 

 

it's probably a question of how the conditional formatting rules are set up. If you could upload an example file, it would be easier to propose a solution.

  • Martin_Weiss's avatar
    Martin_Weiss
    Bronze Contributor
    Jun 21, 2022

    Hi Iain_KNox 

     

    I have changed the formatting rule for the milestone

    From:

    =AND(N$3>=$I4,N$3<=$J4,$D4="milestone")

    Into:

    =AND(N$3<=$I4,O$3>$J4,$D4="milestone")

     

    I have uploaded the changed file, please check there if it fits your needs.

     

    • Iain_KNox's avatar
      Iain_KNox
      Copper Contributor
      Jun 22, 2022

      Martin_Weiss Thanks so much.  I've now added a another conditional to format the Gantt grey based on the % complete.

      Do you know if there is a way I can use the Milestone symbol (Wingdings) in cell D1 for the milestone in the gantt, rather than formatting the cell red?

       

      • Martin_Weiss's avatar
        Martin_Weiss
        Bronze Contributor
        Jun 23, 2022

        Hi Iain_KNox 

         

        the only way I can think of is to put that symbol in every cell of the project plan and make it invisible as a default (user defined number format ;;;)

        And then change the formatting rule to make the symbol visible once the conditions are met.

        I have attached my example.

Resources