I have an excel sheet with several columns. Column b contains dates – several rows could contain the same date. Column c contains a series of values for each date (30, 20, 45, etc).

I want to highlight the cells in column c when they total 120 and only when the dates in column b are the same.

For example b1:b4 are all “05/25/2024” and c1:c4 are 30, 30, 40, 20 then cells c1:c4 would be highlighted. Following, If b2 contained a different date then c1:c4 would not highlight despite totalling 120.