conditional formatting in MS Project





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







0















I need to use conditional formatting to change the colour of the font to white in the 'Cost' field if the figures is between 0-500.
I only want to format the "Cost" field and not the entire row



I would be greateful if someone genius can help me out with this.










share|improve this question





























    0















    I need to use conditional formatting to change the colour of the font to white in the 'Cost' field if the figures is between 0-500.
    I only want to format the "Cost" field and not the entire row



    I would be greateful if someone genius can help me out with this.










    share|improve this question

























      0












      0








      0








      I need to use conditional formatting to change the colour of the font to white in the 'Cost' field if the figures is between 0-500.
      I only want to format the "Cost" field and not the entire row



      I would be greateful if someone genius can help me out with this.










      share|improve this question














      I need to use conditional formatting to change the colour of the font to white in the 'Cost' field if the figures is between 0-500.
      I only want to format the "Cost" field and not the entire row



      I would be greateful if someone genius can help me out with this.







      microsoft-project






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Sep 25 '13 at 6:47









      mariemarie

      112




      112






















          1 Answer
          1






          active

          oldest

          votes


















          1














          Can't be done natively, but can be achieved with some VBA code. I've copied a sample i prepared previously which applies formatting to the flag1 column based on its value. A bit of tweaking should get it doing what you need. You'll need to run the code to refresh - it won't recalculate after each edit.



          I hope that helps,
          Andrew



              Sub ApplyFormattingToFlag1()
          ' ===================================================================================
          ' ===== This section applies the formatting to the current view =====
          ' ===================================================================================
          Dim t As task
          Dim pj As Project
          Dim boo_AnyYes
          Dim app As Application
          Set app = MSProject.Application
          Set pj = activeProject
          boo_AnyYes = False
          For Each t In pj.Tasks

          If t.Flag1 = True Then
          boo_AnyYes = True
          End If

          Next t


          With app
          .ScreenUpdating = False ' Attempt to stop the screen refreshing

          .FilterApply "&All Tasks"
          .OutlineHideSubTasks
          .OutlineShowAllTasks

          .SelectTaskColumn Column:="flag1"

          If boo_AnyYes Then
          .FontEx CellColor:=1, Pattern:=1
          Else
          .FontEx CellColor:=16, Pattern:=0
          End If

          End With
          End Sub





          share|improve this answer
























            Your Answer








            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "3"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f649982%2fconditional-formatting-in-ms-project%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            1














            Can't be done natively, but can be achieved with some VBA code. I've copied a sample i prepared previously which applies formatting to the flag1 column based on its value. A bit of tweaking should get it doing what you need. You'll need to run the code to refresh - it won't recalculate after each edit.



            I hope that helps,
            Andrew



                Sub ApplyFormattingToFlag1()
            ' ===================================================================================
            ' ===== This section applies the formatting to the current view =====
            ' ===================================================================================
            Dim t As task
            Dim pj As Project
            Dim boo_AnyYes
            Dim app As Application
            Set app = MSProject.Application
            Set pj = activeProject
            boo_AnyYes = False
            For Each t In pj.Tasks

            If t.Flag1 = True Then
            boo_AnyYes = True
            End If

            Next t


            With app
            .ScreenUpdating = False ' Attempt to stop the screen refreshing

            .FilterApply "&All Tasks"
            .OutlineHideSubTasks
            .OutlineShowAllTasks

            .SelectTaskColumn Column:="flag1"

            If boo_AnyYes Then
            .FontEx CellColor:=1, Pattern:=1
            Else
            .FontEx CellColor:=16, Pattern:=0
            End If

            End With
            End Sub





            share|improve this answer




























              1














              Can't be done natively, but can be achieved with some VBA code. I've copied a sample i prepared previously which applies formatting to the flag1 column based on its value. A bit of tweaking should get it doing what you need. You'll need to run the code to refresh - it won't recalculate after each edit.



              I hope that helps,
              Andrew



                  Sub ApplyFormattingToFlag1()
              ' ===================================================================================
              ' ===== This section applies the formatting to the current view =====
              ' ===================================================================================
              Dim t As task
              Dim pj As Project
              Dim boo_AnyYes
              Dim app As Application
              Set app = MSProject.Application
              Set pj = activeProject
              boo_AnyYes = False
              For Each t In pj.Tasks

              If t.Flag1 = True Then
              boo_AnyYes = True
              End If

              Next t


              With app
              .ScreenUpdating = False ' Attempt to stop the screen refreshing

              .FilterApply "&All Tasks"
              .OutlineHideSubTasks
              .OutlineShowAllTasks

              .SelectTaskColumn Column:="flag1"

              If boo_AnyYes Then
              .FontEx CellColor:=1, Pattern:=1
              Else
              .FontEx CellColor:=16, Pattern:=0
              End If

              End With
              End Sub





              share|improve this answer


























                1












                1








                1







                Can't be done natively, but can be achieved with some VBA code. I've copied a sample i prepared previously which applies formatting to the flag1 column based on its value. A bit of tweaking should get it doing what you need. You'll need to run the code to refresh - it won't recalculate after each edit.



                I hope that helps,
                Andrew



                    Sub ApplyFormattingToFlag1()
                ' ===================================================================================
                ' ===== This section applies the formatting to the current view =====
                ' ===================================================================================
                Dim t As task
                Dim pj As Project
                Dim boo_AnyYes
                Dim app As Application
                Set app = MSProject.Application
                Set pj = activeProject
                boo_AnyYes = False
                For Each t In pj.Tasks

                If t.Flag1 = True Then
                boo_AnyYes = True
                End If

                Next t


                With app
                .ScreenUpdating = False ' Attempt to stop the screen refreshing

                .FilterApply "&All Tasks"
                .OutlineHideSubTasks
                .OutlineShowAllTasks

                .SelectTaskColumn Column:="flag1"

                If boo_AnyYes Then
                .FontEx CellColor:=1, Pattern:=1
                Else
                .FontEx CellColor:=16, Pattern:=0
                End If

                End With
                End Sub





                share|improve this answer













                Can't be done natively, but can be achieved with some VBA code. I've copied a sample i prepared previously which applies formatting to the flag1 column based on its value. A bit of tweaking should get it doing what you need. You'll need to run the code to refresh - it won't recalculate after each edit.



                I hope that helps,
                Andrew



                    Sub ApplyFormattingToFlag1()
                ' ===================================================================================
                ' ===== This section applies the formatting to the current view =====
                ' ===================================================================================
                Dim t As task
                Dim pj As Project
                Dim boo_AnyYes
                Dim app As Application
                Set app = MSProject.Application
                Set pj = activeProject
                boo_AnyYes = False
                For Each t In pj.Tasks

                If t.Flag1 = True Then
                boo_AnyYes = True
                End If

                Next t


                With app
                .ScreenUpdating = False ' Attempt to stop the screen refreshing

                .FilterApply "&All Tasks"
                .OutlineHideSubTasks
                .OutlineShowAllTasks

                .SelectTaskColumn Column:="flag1"

                If boo_AnyYes Then
                .FontEx CellColor:=1, Pattern:=1
                Else
                .FontEx CellColor:=16, Pattern:=0
                End If

                End With
                End Sub






                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered May 30 '14 at 22:23









                Andrew - Eversight LtdAndrew - Eversight Ltd

                1261




                1261






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Super User!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f649982%2fconditional-formatting-in-ms-project%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    "Incorrect syntax near the keyword 'ON'. (on update cascade, on delete cascade,)

                    Alcedinidae

                    RAC Tourist Trophy