I've been asked to apply conditional formatting to a series of arrays (one for every month of the year).

Each array is defined by a list of the same 10 wells on the left header column and each day of them month on the top header row.

Currently, there are three conditional formatting rules applied to each cell within the array: color the cell gray if condition 1 is met, red if condition 2 is met and green if condition 3 is met.

Currently, each of the 310 cells needs to be individually programmed with three conditional formatting rules to compare the look up the well ID and date then compare the conditions to another table where the three conditions are defined. I want to update it so I don't have to write 310 * 3 conditional formatting rules to complete each month's array.

Anyone have any ideas?