What Are You Doing Right Now
-
@DustinB3403 said in What Are You Doing Right Now:
@dafyre said in What Are You Doing Right Now:
Bashing my head against my keyboard. Trying to figure out how to do conditional formatting on an ENTIRE ROW with LibreOffice Calc.
Now let me see you do that and make it work for an ENTIRE ROW in one shot without having to do each cell one at a time.
I can do it with my eyes closed for one Cell, lol.
-
-
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.
-
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
-
@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!
-
@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 -
@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 toYou have a point, it is friday afternoon.
-
@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 toYou 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
-
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).
-
@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 toYou 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.
-
@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 toYou 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.
-
@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 toYou 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.
-
@dafyre said in What Are You Doing Right Now:
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).
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?
-
@DustinB3403 said in What Are You Doing Right Now:
@dafyre said in What Are You Doing Right Now:
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).
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%)
-
@DustinB3403 said in What Are You Doing Right Now:
@dafyre said in What Are You Doing Right Now:
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).
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
-
@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:
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).
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
-
@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:
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).
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
Sigh... )(@_#&$)(_&@#$ Quotation marks!
All the reading I've seen today and not a single post showed that. Thank you.
-
@dafyre Also note the range at the bottom.
That has to be changed or else it defaults to some odd combo.
-
@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.
-
Working around the kids
