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.
    • DustinB3403D
      DustinB3403 @dafyre
      last edited by

      @dafyre soffice.bin_2019-02-08_14-59-06.png

      1 Reply Last reply Reply Quote 0
      • 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
                                            • 1
                                            • 2
                                            • 3426
                                            • 3427
                                            • 3428
                                            • 3429
                                            • 3430
                                            • 4443
                                            • 4444
                                            • 3428 / 4444
                                            • First post
                                              Last post