CF for summing a specific number of columns

[Newbienew]

Great day Experts,

I have a spread sheet with 2022-2024 with 12 months broken down into four quarters. Within the collective quarter, the total sum is to be equal to or great than five. The issue that I am faced with is having to repeat the same formula for every three cell columns, and I wanted to know if there is an easier way of achieving this with one formula across a large area. Thank you for you help in advance

Book1
	A	B	C	D	E	F	G	H	I
1	2	3	4	2	2	3	2	1	4
Sheet1

 

[Peter_SSs]

Can you put some sample data and expected results into a worksheet, post that with XL2BB and explain with reference to that sample data?

 

[Newbienew]

I thought I attached a mini mock version. Below is a another version just a tad bigger. It will not show the formula i am using in A-C and D-F

=IF(SUM($A2:$C2)>=5,TRUE,0) =IF(SUM($D2:$F2)>=5,TRUE,0)

JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP
2	3	4	2	2	3	2	1	4
1	1	1	2	2	3	2	1	4
2	2	1	1	2	1	2	1	4

 

[Newbienew]

I thought I attached a mini mock version. Below is a another version just a tad bigger. It will not show the formula i am using in A-C and D-F

=IF(SUM($A2:$C2)>=5,TRUE,0) =IF(SUM($D2:$F2)>=5,TRUE,0)

JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP
2	3	4	2	2	3	2	1	4
1	1	1	2	2	3	2	1	4
2	2	1	1	2	1	2	1	4

So, in this small version, the formula would have to be for ABC columns and then repeated again for DEF columns. There is no CF in GHI, but I'm looking for an area CF that will allow me to do the same thing on a larger scale.

 

[Peter_SSs]

I thought I attached a mini mock version.

You did but it mentioned 12 months but there were no month labels and only 9 columns and it showed G1:I1 with a total >=5 but no formatting so it was a complete guess at what you actually had/wanted.

I think after your following 2 posts I now understand. Is this it?

24 10 08.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1	JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
2	2	3	4	2	2	3	2	1	4
3	1	1	1	2	2	3	2	1	4
4	2	2	1	1	2	1	2	1	4
CF>=5

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:L4	Expression	=SUM(OFFSET(A2,,-MOD(COLUMNS($A:A)-1,3),,3))>=5	text	NO

 

[Newbienew]

Thank you very much. This is right on the marker.

 

[Peter_SSs]

You are welcome. Glad to help. Thanks for the follow-up.