You are viewing a single comment's thread from:

RE: Boost thy bounty!

in PRAETORIA3 months ago

My eyes are burning. But I did not cry. Yet. My GF is next door painting, checking in on my from time to time, puzzled when I try to explain. Each one has their art... Though I'm not on the "artist" level at statistics yet the "rather good" from you is like a "amazing!" from every other person 😅

I was thinking about that. I even prepared a different sheet to have the crossing points being marked in the diagramm, with if(x=Y;NV()) and all that, but then I realized that the crossing points are mostly on certain days, and I'd have to do the 10k days. And I didn't want to.

And it's already 1000 words, and if someone wants to calculate - I built the calculator.

Sort:  

Why do you think all my plots/charts have black/dark background? Because I am a professional :)

That burning in the eye is very real and chronic! :)

Change everything that you have, word excel PowerPoint, you browser, PeakD peakmonsters….. everything to dark mode!

Thank me later

I do have everything on dark mode. Can I put the sheet in dark mode, too? because the excel itself is.

image.png

I didn't find any darker than that...

Sure that white burns my eye!

Yes the whole sheet will be black and text white.

Just google it :)

Dark mode the world!

Surely, it would be a better world...

IMG_1332.jpeg

Run this macro.

Sub DarkModeSheet()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Sheets
ws.Cells.Interior.Color = RGB(30, 30, 30)
ws.Cells.Font.Color = RGB(255, 255, 255)
Next ws
End Sub

Found it! Was kind of obvious, but I didn't see it... SO much better now.

image.png

And no, I'm not hacking my laptop that way. Not that confident, yet. ... ... Anyway, I was too curious, wanted to see what happens. It opened a PowerQuery Editor in Excel. Took a while to load, so I guess it's some kind of wicked witchery. Did it on Desktop, but it just lowered the brightness of the screen - I already knew that one. Windows doesn't know a VBA Editor, at least not for now. And I'm off not. It's getting late. GF finished her painting, time for a beer on the rooftop. Still can't believe you called my plotting "rather good". Going to mark this day in my calendar 😜

With black cells and white text in excel you have officially reached a good apprenticeship level!

Congratulations! :)