HI,
I have some conditional formatting applied to a table with the formula:
=SUMIF($A$2:$A$499,$A1,$T$2:$T$499)>2272
Which highlights the rows in red.
This works perfectly however I want to advance it a bit more so that if the values in column "A" = 6, 7, 10, 11, 14, 15, 18, 19, 22, 23, 26, 27, 30, 31, 34, 35, 38, 39, 42, 43, 46, 47, 50, 51 and the total of column "T" is > 2272 highlight the row red.
And if values in column "A" = 8, 9, 12, 13, 16, 17, 20, 21, 24, 25, 28, 29, 32, 33, 36, 37, 40, 41, 44, 45, 48, 49 and the total in column "T" is > 1704 highlight the row red.
I hope this makes sense,
Thanks in advance!
I have some conditional formatting applied to a table with the formula:
=SUMIF($A$2:$A$499,$A1,$T$2:$T$499)>2272
Which highlights the rows in red.
This works perfectly however I want to advance it a bit more so that if the values in column "A" = 6, 7, 10, 11, 14, 15, 18, 19, 22, 23, 26, 27, 30, 31, 34, 35, 38, 39, 42, 43, 46, 47, 50, 51 and the total of column "T" is > 2272 highlight the row red.
And if values in column "A" = 8, 9, 12, 13, 16, 17, 20, 21, 24, 25, 28, 29, 32, 33, 36, 37, 40, 41, 44, 45, 48, 49 and the total in column "T" is > 1704 highlight the row red.
I hope this makes sense,
Thanks in advance!