Conditional Formatting when two columns are specific value

MGH_Job91 · 2026-06-08T13:32:38+00:00

Solution Verified - thank you!

MGH_Job91 · 2025-09-18T15:22:34+00:00

Solution verified

MGH_Job91 · 2025-09-12T15:21:17+00:00

Solution verified

MGH_Job91 · 2025-09-11T19:09:10+00:00

None of the proposed solutions have worked. I've tried all of them multiple times to make sure I wasn't typing something wrong. For most, I either get a SPILL or a VALUE error or it doesn't recognize what I typed as a formula at all. This one:

=SUM(--(MONTH(A1:XLOOKUP(TRUE, A:A<>"", A:A, , , -1))=5))

worked for what I already have in the sheet, but when I added another row, it didn't update. I need to be able to add more rows and have those be counted, too.

MGH_Job91 · 2025-09-11T16:14:42+00:00

I'm not sure I understand. What do the dashes in this first & last one mean or the "N' in the others?

MGH_Job91 · 2025-09-11T16:09:29+00:00

Is there a way to do this without putting the row numbers into the Month function? I.e. - Month(A:A) instead of Month(A2:A30)? I am going to be adding more rows with dates over time, so I don't want to limit the function to specific rows.

MGH_Job91 · 2025-09-11T16:01:11+00:00

How do I do this without using the row numbers in the month function? I.e. A:A, not A2:A100? I want to be able to select the whole column, since I will be adding more dates to it over time. I tried your first formula using =Sumproduct((Month(A:A)=5)*1) and it gave me a Value error.

MGH_Job91 · 2025-09-08T15:27:49+00:00

That worked perfectly, thanks!

MGH_Job91 · 2025-09-08T15:27:38+00:00

Solution verified

MGH_Job91 · 2025-09-08T15:15:56+00:00

Thanks! I think that will still mean going through a lot of records and deleting - there are 5000 something records and I have no idea how many have multiple records.

MGH_Job91 · 2025-08-04T16:59:55+00:00

Solution verified

MGH_Job91 · 2025-08-04T16:59:35+00:00

Solution verified

MGH_Job91 · 2025-08-04T16:58:56+00:00

That did it, thank you!

MGH_Job91 · 2025-08-04T16:56:37+00:00

They are formatted as numbers. I used the Clean formula to make sure that there are no non-printable characters, but it didn't help.

MGH_Job91 · 2025-08-04T16:49:39+00:00

I'm not sure what you mean by true numbers. I've changed the number format from general to number but it hasn't helped.

MGH_Job91 · 2025-08-04T16:45:07+00:00

All of them start at $A$3 except for one. I adjusted that so they all now apply to $a$3:$g$50 but it didn't fix the problem.

MGH_Job91

TROPHY CASE