I have a table in which the items with a low days of coverage are listed. The item are splitted by IDs and Distribution Centers. So, I have the item "1" in the distribution centers "550" and "410" that have low days of coverage. This item is listed in the table, as you can see in this screenshot below.
I also have another table on another sheet which contains the data for the item in every distribution center, as you can see here:
As you can see, other distribution centers have 85+ days of coverage. If this condition is met, I'd like to flag it in the first table with a background color in the DOC (OH+OO) cell.