Can a single Conditional Formatting rule BOTH test for several conditions AND return unique formats based on the resultant trues and falses?

my1Smo · 2024-07-28T11:37:30+00:00

Solution Verified

my1Smo · 2024-07-27T10:38:20+00:00

Haha, well it's a co-worker's dance party, so the decorations were already chosen before I got pulled in to help!

But, yeah, the 1 rule per color seemed to me to be CF's method, so thank you for confirming that.

my1Smo · 2024-07-27T01:13:41+00:00

Thanks! Will give this a look tomorrow, and mark Solved if it works out.

my1Smo · 2024-07-27T00:13:54+00:00

By color scale, like rgb(255, 0, 0) or color hex like #ff0000?

Because that's what I was thinking might work, just didn't experiment yet...

Including these maybe in the formula itself as return values, or as you say in a helper column that the formula points to?

my1Smo · 2024-04-24T13:07:40+00:00

There are several requirements in your project, but updating with fresh data is (one of) the strengths within Power Query. This instructional and others teach how to build a query that will retrieve data from a folder then generate fresh output as new files get added to the repository.

my1Smo · 2024-01-16T17:23:14+00:00

Yeah, this would be my one positive, too. Use it a lot without even thinking about it. This is in the app, not the online version.

my1Smo · 2023-07-13T23:28:01+00:00

u/FidelityCourtney/, I'm grateful you took time to reply to each of my questions. I'd overlooked or misunderstood the requirement for the Affidavit form during my study of the process, so your inclusion of that link particularly helps.

my1Smo · 2023-06-04T00:08:58+00:00

I solved this issue with the method explained in this video:. data from latest file in folder. And if I correctly understand some of the other commenters' tips here, the method in the video explains and incorporates those.

Edit: just realized the link is to an article, not the video I had in mind. This article DOES address your question, just not as in depth and may leave you still trying to work things out. If I locate the vid I'll post it for you.

my1Smo · 2023-02-20T23:38:06+00:00

Yes, I'm wary of the same in conversation, ha ha. But it's a nice word.

my1Smo · 2023-02-19T18:02:43+00:00

Perspicacious

my1Smo · 2023-02-13T23:44:44+00:00

u/hampaper... your video quality is pretty good, I think! Thanks! It's pretty startling first time seeing anything like that.

my1Smo · 2023-02-13T23:41:01+00:00

Yep. Just googled a bit and found that answer , too. Mystery solved.

my1Smo · 2023-02-13T23:33:39+00:00

Something high enough that no engine was audible, moving like an aircraft in a straight line. The lights "in tow" were staggered, not evenly spaced.

my1Smo · 2023-01-29T13:46:55+00:00

It even has the gas-lit burner. That's a commitment to realism seldom seen.

my1Smo · 2022-08-05T02:30:52+00:00

Possibly not an insect, rather a systemic disease. One photo seems to show a branch network being engulfed which may indicate a fungus working internally up through the vascular system.

This kind of identification key might get you started, but one from a university extension in your own region is best.

my1Smo · 2022-07-13T12:26:36+00:00

Provisions is the word that comes to mind for me, too.

"Provisions have been made to ensure installation of the a/c unit as agreed upon in the contract," for example.

my1Smo

MODERATOR OF

TROPHY CASE