Conditional Formatting with nested VLOOKUP function?

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?

I think I've uploaded a file, but this interface leaves a lot to be desired.

Programming Test Case.xlsx

I understand what your saying about formatting the dates, and agree. They way the original author has the dates all cut up, I figured I would replace the days of the month with the real date and simply customize the date format to reflect the day only. Your use of index and match works quite nicely. An associate taught me that one last year, but I've not used it since.

Thanks for your help. It works wonderfully.