Conditional Formatting

[lfellows]

I need help with conditional formatting and I'm not sure if what I want is even possible: I have data stored in a table. In column A is a week number i.e. 45, 46, 47 etc. In column C I have numbers which are totals of something that can vary from 1 to 300. Is there a way I can highlight all rows that contain the same week number in column A red when the total of all corresponding numbers in C column exceeds a certain value? I hope this clear. Thanks!

 

[Peter_SSs]

Is there a way I can highlight all rows that contain the same week number in column A red when the total of all corresponding numbers in C column exceeds a certain value?

Like this if the total for a particular week number exceeds 500?

Select A2:C12 and apply the Conditional Formatting shown.

xl2bb.xlam
	A	B	C
1	Week	Other	Totals
2	1	data 1	67
3	2	data 2	109
4	3	data 3	219
5	2	data 4	132
6	1	data 5	165
7	2	data 6	133
8	3	data 7	242
9	4	data 8	176
10	3	data 9	44
11	2	data 10	229
12	1	data 11	224
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:C12	Expression	=SUMIF($A$2:$A$12,$A2,$C$2:$C$12)>500	text	NO

 

[lfellows]

Outstanding thank you!

 

[Peter_SSs]

Outstanding thank you!

You're welcome. Thanks for the confirmation.