I have a table with data set against dates, ie test results against test dates.
Some days 3 tests are performed, some days two.

eg
date result
day1 a 10
day1 b 11
day2 a 10
day2 b 15
day2 c 14
day3 a 11
day3 b 10

I want to format column B to highlight results above a certain value.
however, the limits for highlighting are different depending on the number of tests in a day.
eg day with 2 tests limit = 15
day with 3 tests limit = 11
conditionally formatting the column wont work as it wont differentiate between tests per day.
Is there a way of getting around this?
Theres a lot of data and trying to separate the twos and threes would be a nightmare!