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?