ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    What Are You Doing Right Now

    Water Closet
    time waster
    285
    88.9k
    41.3m
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • dafyreD
      dafyre
      last edited by

      Now when you separate those out into columns and tell it to apply GOOD when Cell Value is = 1, does it apply that to ALL the cells in the row, or just once cell?

      I've done exactly what you are doing and getting only one cell highlighted and not my entire row.

      1 Reply Last reply Reply Quote 0
      • WrCombsW
        WrCombs
        last edited by

        So we had a meeting to discuss moving forward and my boss made this comment :

        "Guys, Dont be afraid to get on to the forum and list servers via email and ask questions. Will, You are really good about getting the question out there and asking questions giving information. Keep that up and dont be afraid to use it as we move forward."

        SO Thank you ML for teaching me how to ask questions in an open forum such as this one 😄

        DustinB3403D 1 Reply Last reply Reply Quote 5
        • DustinB3403D
          DustinB3403 @WrCombs
          last edited by

          @WrCombs said in What Are You Doing Right Now:

          SO Thank you ML for teaching me how to ask questions in an open forum such as this one 😄

          Shut up and get back to work already!

          WrCombsW 1 Reply Last reply Reply Quote 0
          • WrCombsW
            WrCombs @DustinB3403
            last edited by

            @DustinB3403 said in What Are You Doing Right Now:

            @WrCombs said in What Are You Doing Right Now:

            SO Thank you ML for teaching me how to ask questions in an open forum such as this one 😄

            Shut up and get back to work already!

            LOL
            But I really dont want to

            DustinB3403D 1 Reply Last reply Reply Quote 1
            • DustinB3403D
              DustinB3403 @WrCombs
              last edited by

              @WrCombs said in What Are You Doing Right Now:

              @DustinB3403 said in What Are You Doing Right Now:

              @WrCombs said in What Are You Doing Right Now:

              SO Thank you ML for teaching me how to ask questions in an open forum such as this one 😄

              Shut up and get back to work already!

              LOL
              But I really dont want to

              You have a point, it is friday afternoon.

              WrCombsW dafyreD 2 Replies Last reply Reply Quote 1
              • WrCombsW
                WrCombs @DustinB3403
                last edited by

                @DustinB3403 said in What Are You Doing Right Now:

                @WrCombs said in What Are You Doing Right Now:

                @DustinB3403 said in What Are You Doing Right Now:

                @WrCombs said in What Are You Doing Right Now:

                SO Thank you ML for teaching me how to ask questions in an open forum such as this one 😄

                Shut up and get back to work already!

                LOL
                But I really dont want to

                You have a point, it is friday afternoon.

                exactly! I should be bottoms up to a patron marg right about now. but instead, i'm drinking coffee

                1 Reply Last reply Reply Quote 0
                • dafyreD
                  dafyre
                  last edited by

                  @DustinB3403 :

                  Line 4 is what I get when selecting row 4 and applying the conditional formatting.

                  Line 6 is what I expect to get (note, I had to manually highlight line 6, not what I want to do).

                  36e86937-f2fa-41b1-a884-7ad10b0c575d-image.png

                  DustinB3403D 1 Reply Last reply Reply Quote 0
                  • dafyreD
                    dafyre @DustinB3403
                    last edited by

                    @DustinB3403 said in What Are You Doing Right Now:

                    @WrCombs said in What Are You Doing Right Now:

                    @DustinB3403 said in What Are You Doing Right Now:

                    @WrCombs said in What Are You Doing Right Now:

                    SO Thank you ML for teaching me how to ask questions in an open forum such as this one 😄

                    Shut up and get back to work already!

                    LOL
                    But I really dont want to

                    You have a point, it is friday afternoon.

                    We all just got out of a 2 hour meeting. I don't foresee anybody getting anything done the rest of the afternoon.

                    WrCombsW 1 Reply Last reply Reply Quote 1
                    • WrCombsW
                      WrCombs @dafyre
                      last edited by

                      @dafyre said in What Are You Doing Right Now:

                      @DustinB3403 said in What Are You Doing Right Now:

                      @WrCombs said in What Are You Doing Right Now:

                      @DustinB3403 said in What Are You Doing Right Now:

                      @WrCombs said in What Are You Doing Right Now:

                      SO Thank you ML for teaching me how to ask questions in an open forum such as this one 😄

                      Shut up and get back to work already!

                      LOL
                      But I really dont want to

                      You have a point, it is friday afternoon.

                      We all just got out of a 2 hour meeting. I don't foresee anybody getting anything done the rest of the afternoon.

                      those are the absolute worse.

                      dafyreD 1 Reply Last reply Reply Quote 0
                      • dafyreD
                        dafyre @WrCombs
                        last edited by

                        @WrCombs said in What Are You Doing Right Now:

                        @dafyre said in What Are You Doing Right Now:

                        @DustinB3403 said in What Are You Doing Right Now:

                        @WrCombs said in What Are You Doing Right Now:

                        @DustinB3403 said in What Are You Doing Right Now:

                        @WrCombs said in What Are You Doing Right Now:

                        SO Thank you ML for teaching me how to ask questions in an open forum such as this one 😄

                        Shut up and get back to work already!

                        LOL
                        But I really dont want to

                        You have a point, it is friday afternoon.

                        We all just got out of a 2 hour meeting. I don't foresee anybody getting anything done the rest of the afternoon.

                        those are the absolute worse.

                        Purdy much.

                        1 Reply Last reply Reply Quote 1
                        • DustinB3403D
                          DustinB3403 @dafyre
                          last edited by

                          @dafyre said in What Are You Doing Right Now:

                          @DustinB3403 :

                          Line 4 is what I get when selecting row 4 and applying the conditional formatting.

                          Line 6 is what I expect to get (note, I had to manually highlight line 6, not what I want to do).

                          36e86937-f2fa-41b1-a884-7ad10b0c575d-image.png

                          Conditional formatting is per cell. Not per Row.

                          So each cell would need to have it's own condition. But you want the row to be highlighted green based on what value?

                          dafyreD 2 Replies Last reply Reply Quote 0
                          • dafyreD
                            dafyre @DustinB3403
                            last edited by

                            @DustinB3403 said in What Are You Doing Right Now:

                            @dafyre said in What Are You Doing Right Now:

                            @DustinB3403 :

                            Line 4 is what I get when selecting row 4 and applying the conditional formatting.

                            Line 6 is what I expect to get (note, I had to manually highlight line 6, not what I want to do).

                            36e86937-f2fa-41b1-a884-7ad10b0c575d-image.png

                            Conditional formatting is per cell. Not per Row.

                            So each cell would need to have it's own condition. But you want the row to be highlighted green based on what value?

                            If the Value in Column K is bigger than 0.5 (50%)

                            1 Reply Last reply Reply Quote 0
                            • dafyreD
                              dafyre @DustinB3403
                              last edited by

                              @DustinB3403 said in What Are You Doing Right Now:

                              @dafyre said in What Are You Doing Right Now:

                              @DustinB3403 :

                              Line 4 is what I get when selecting row 4 and applying the conditional formatting.

                              Line 6 is what I expect to get (note, I had to manually highlight line 6, not what I want to do).

                              36e86937-f2fa-41b1-a884-7ad10b0c575d-image.png

                              Conditional formatting is per cell. Not per Row.

                              So each cell would need to have it's own condition. But you want the row to be highlighted green based on what value?

                              Must be something in LibreOffice... I just tested it with Excel 2016 and I can highlight a whole row with no problem

                              1 Reply Last reply Reply Quote 0
                              • DustinB3403D
                                DustinB3403
                                last edited by

                                @dafyre said in What Are You Doing Right Now:

                                @DustinB3403 said in What Are You Doing Right Now:

                                @dafyre said in What Are You Doing Right Now:

                                @DustinB3403 :

                                Line 4 is what I get when selecting row 4 and applying the conditional formatting.

                                Line 6 is what I expect to get (note, I had to manually highlight line 6, not what I want to do).

                                36e86937-f2fa-41b1-a884-7ad10b0c575d-image.png

                                Conditional formatting is per cell. Not per Row.

                                So each cell would need to have it's own condition. But you want the row to be highlighted green based on what value?

                                Must be something in LibreOffice... I just tested it with Excel 2016 and I can highlight a whole row with no problem

                                Here

                                soffice.bin_2019-02-08_15-29-55.png

                                dafyreD 1 Reply Last reply Reply Quote 0
                                • dafyreD
                                  dafyre @DustinB3403
                                  last edited by

                                  @DustinB3403 said in What Are You Doing Right Now:

                                  @dafyre said in What Are You Doing Right Now:

                                  @DustinB3403 said in What Are You Doing Right Now:

                                  @dafyre said in What Are You Doing Right Now:

                                  @DustinB3403 :

                                  Line 4 is what I get when selecting row 4 and applying the conditional formatting.

                                  Line 6 is what I expect to get (note, I had to manually highlight line 6, not what I want to do).

                                  36e86937-f2fa-41b1-a884-7ad10b0c575d-image.png

                                  Conditional formatting is per cell. Not per Row.

                                  So each cell would need to have it's own condition. But you want the row to be highlighted green based on what value?

                                  Must be something in LibreOffice... I just tested it with Excel 2016 and I can highlight a whole row with no problem

                                  Here

                                  soffice.bin_2019-02-08_15-29-55.png

                                  Sigh... )(@_#&$)(_&@#$ Quotation marks!

                                  All the reading I've seen today and not a single post showed that. Thank you.

                                  DustinB3403D 1 Reply Last reply Reply Quote 0
                                  • DustinB3403D
                                    DustinB3403 @dafyre
                                    last edited by

                                    @dafyre Also note the range at the bottom.

                                    That has to be changed or else it defaults to some odd combo.

                                    dafyreD 1 Reply Last reply Reply Quote 0
                                    • dafyreD
                                      dafyre @DustinB3403
                                      last edited by

                                      @DustinB3403 said in What Are You Doing Right Now:

                                      @dafyre Also note the range at the bottom.

                                      That has to be changed or else it defaults to some odd combo.

                                      Yeah, I see that bit... but it seems that no matter what I fiddle it to, it just doesn't want to cooperate. But you got me pointed in a good direction, so I can go back to tinkering again.

                                      1 Reply Last reply Reply Quote 0
                                      • dbeatoD
                                        dbeato
                                        last edited by

                                        Working around the kids 🙂

                                        DustinB3403D 1 Reply Last reply Reply Quote 0
                                        • DustinB3403D
                                          DustinB3403 @dbeato
                                          last edited by

                                          @dbeato said in What Are You Doing Right Now:

                                          Working around the kids 🙂

                                          Finally building that concrete cage around them that we discussed a few weeks ago?

                                          dbeatoD 1 Reply Last reply Reply Quote 0
                                          • dbeatoD
                                            dbeato @DustinB3403
                                            last edited by

                                            @DustinB3403 said in What Are You Doing Right Now:

                                            @dbeato said in What Are You Doing Right Now:

                                            Working around the kids 🙂

                                            Finally building that concrete cage around them that we discussed a few weeks ago?

                                            Lol, I am not sure I remember that but no.

                                            dafyreD 1 Reply Last reply Reply Quote 0
                                            • 1
                                            • 2
                                            • 3
                                            • 4
                                            • 5
                                            • 4443
                                            • 4444
                                            • 3 / 4444
                                            • First post
                                              Last post