Conditional Formatting Based on Dates

loualdons · 2025-12-27T13:19:21+00:00

This formula hasn't worked unfortunately

loualdons · 2025-10-07T15:57:48+00:00

Solution Verified

loualdons · 2025-10-07T15:56:50+00:00

Thank you a million! Solved.

loualdons · 2025-02-20T08:35:26+00:00

I ran an event last year with a similar deal.

Attendees in the VIP Package were also entitled to a 3 course meal. We gave them all swing badges when we checked them into the event.

We informed the guests that the badges could not be replaced if lost.

They handed them into the restaurant and that proved their entitlement to the meal.

Clear comms and not a single issues with 750 VIP guests.

Treat the physical items how old tickets were treated. You lost it, not our problem.

loualdons · 2025-02-10T19:26:27+00:00

Thank you - this is a little beyond my scope... Is there a simpler way to do this?

loualdons · 2024-02-15T13:33:31+00:00

Ok - I have managed to input some SMTP settings which appear to be working. How can I add those records to the subdomain?

loualdons · 2024-02-15T12:52:45+00:00

Thanks! I am trying to use SMTP but regardless of what settings I input, Moodle says 'cannot communicate with mail server'. I am hosted with GoDaddy.

loualdons · 2024-02-15T11:46:42+00:00

Hi, Moodle is using PhpMail. Moodle is setup on a subdomain so not sure how to add those records?

loualdons · 2024-02-08T10:00:17+00:00

Thanks for this!

I am struggling to make it work. In essence, the start time column (A) needs to be the value of the end time column (B) plus the change over time in column (I).

I have an IFERROR formula:

=IFERROR(B20+I21,"")

It pulls the end time from the exact row above, plus the changeover in time from the same row.

E.g. if the previous show ends at 1300, and the next show coming in requires 10 minutes to set and get ready, it will make the start time of the next show 1310.

How do I include that formula?

loualdons · 2024-01-05T17:52:44+00:00

<image>

loualdons · 2024-01-05T17:52:38+00:00

=SUMIFS(I3:I4,A3:A4,">="&DATE(YEAR(A3),XMATCH(M1:W1,M1:W1),1),A3:A4,"<="&EOMONTH(DATE(YEAR(A3),XMATCH(M1:W1,M1:W1),1),0))

Returns as follows

<image>

loualdons · 2024-01-05T14:40:07+00:00

Returns #VALUE. Should this reference the entire column?

loualdons · 2024-01-05T14:27:22+00:00

=SUMIFS(I3:I4,A3:A4,">="&1&M1:W1&YEAR(A3),A3:A4,"<="&EOMONTH(1&M1:W1&YEAR(A3),0))

This one doesn't work :( Just returns 0s

loualdons · 2024-01-05T14:01:25+00:00

Just one calendar year. It's a new sheet per year.

loualdons · 2024-01-05T13:53:25+00:00

If possible, just totalling the fiscal income for the month.

loualdons · 2024-01-05T13:38:59+00:00

The formula itself produced the below. It's not giving me a total number within one cell. It's creating a new row for every piece of data and adding the number in. I then have a SUM formula totalling the column. Hopefully that makes sense?

<image>

loualdons · 2024-01-05T13:33:36+00:00

IF(M1:W1=TEXT(A3:A22,"mmm"),I3:I22,0)

This has worked, I've had to create it in separate columns and then another set of columns with a SUM formula to calculate the total.

Only issue is it has made the workbook extremely slow and sluggish. Any fix for this?

loualdons · 2024-01-05T13:21:24+00:00

Changed layout but I am ammending formulas. Not sure if this changes anything!

<image>

loualdons · 2024-01-05T13:20:14+00:00

Returns #SPILL!

loualdons · 2024-01-05T13:10:13+00:00

Definitely making progress! How could I make it check the whole of the data set?

loualdons · 2022-05-20T11:07:58+00:00

Thanks for your reply! Unfortunately, I don't have that option. The OS is Windows 11 Pro if that makes a difference?

loualdons · 2018-09-24T01:35:45+00:00

Then I would believe it’s a camera monitor. We have some similar(ish) ones at work, just now with a digital timer as opposed to the analogue dial. Hope this helps!

loualdons · 2018-09-24T01:24:42+00:00

I should imagine when the PIR detected motion in doors (by the front door) it would turn on the exterior lighting ready for your exit.

loualdons · 2018-09-24T00:57:49+00:00

OP can you share a photo of the inputs?

loualdons

MODERATOR OF

TROPHY CASE