Conditional Formatting

lfellows

New Member
Joined
Nov 22, 2019
Messages
3
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

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
41,790
Office Version
365
Platform
Windows
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
ABC
1WeekOtherTotals
21data 167
32data 2109
43data 3219
52data 4132
61data 5165
72data 6133
83data 7242
94data 8176
103data 944
112data 10229
121data 11224
CF
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A2:C12Expression=SUMIF($A$2:$A$12,$A2,$C$2:$C$12)>500textNO
 

Forum statistics

Threads
1,078,289
Messages
5,339,327
Members
399,293
Latest member
maras

Some videos you may like

This Week's Hot Topics

Top