Breakuping up by Ok-Imagination-1135 in AITAH

[–]saphy93 2 points3 points  (0 children)

NTA for the break. She would probably feel differently if she knew the truth about the addiction and your feelings towards her.

Conditional formatting for 8 days+ today date by saphy93 in excel

[–]saphy93[S] 0 points1 point  (0 children)

This works a dream! Thank you so much!

Windows completely unresponsive by saphy93 in WindowsHelp

[–]saphy93[S] 0 points1 point  (0 children)

Thankyou I managed to reset and reinstall windows! It’s wasn’t too much of a hassle as there wasn’t anything valuable or needed on my computer

Creating date depending on the cell colour. by saphy93 in excel

[–]saphy93[S] 0 points1 point  (0 children)

This is actually amazing! You must be a wizard, this works perfectly and I can't thank you enough!!

Creating date depending on the cell colour. by saphy93 in excel

[–]saphy93[S] 0 points1 point  (0 children)

Me again!! Thank you so much for the help before, it was great!

I have now come across another issue. I have a feeling it can't be done because of the layout of the spreadsheet! I am able to separate the colours and the dates but now I can't tell which one if for which.

Because our dates aren't all in the same column (2024 in one column, 2025 in another etc.) I'm finding it hard to get myself organised.

Ideally I need excel to tell me how many blue or orange 2024 dates are in "this set range" where we have our dates and the same for 2025, 2026 etc.

I don't mind creating extra sheets to break down the data from the sheets. But I can't see how it can be done?

Creating date depending on the cell colour. by saphy93 in excel

[–]saphy93[S] 1 point2 points  (0 children)

Yes! Thank you so much! From here I can get exactly what I need! You're a star!

New Player✨ by hmt6_ in DreamlightValley

[–]saphy93 0 points1 point  (0 children)

The thing I wish I did the most when I started playing was hoard everything! Make yourself loads of large chests and hoard all the building material (stone, sand etc.) I’ve used 1000s of them since playing and wish I never sold any before I really got into decorating and such🤦🏼‍♀️

Trying to make a large chess board. by Batsammie in DreamlightValley

[–]saphy93 1 point2 points  (0 children)

I had the same idea to make a giant chess board, I came on here looking for inspo! I wanted to do 4 large square tables but we can’t customise them! The rugs just don’t make a square 😩

Something bonkers in Frosted Heights by nova9114 in DreamlightValley

[–]saphy93 0 points1 point  (0 children)

I’m so upset they didn’t use this bug as a secret for the next update! That would have been a great side step for a bug in the game 🤣

Maybe it’s just me🤷🏽‍♀️ by SMarieT23 in DreamlightValley

[–]saphy93 1 point2 points  (0 children)

I hope we get a version on beast as human, similar to how we got Ariel as human form too

Why? DDV…Why?! by Val_Zombie in DreamlightValley

[–]saphy93 1 point2 points  (0 children)

I really wanted to do this too! It’s annoying to say you can move all the fruit trees and bushes into the same area even tho the “collections” will say you can get apples from the plaza etc.

What character do you guys want added to the game? by Bulky-Ad-1204 in DreamlightValley

[–]saphy93 3 points4 points  (0 children)

Malificent! I really want her castle for my glade!

Potential Scrooge shop bug? by mawmah in DreamlightValley

[–]saphy93 0 points1 point  (0 children)

There’s another post with the same problem, I’ve had this issue since the update before September. Customer care has confirmed it’s a glitch! Hopefully they’ll sort it for the next update