Hello, I am trying to highlight cells based on multiple values of the cell itself and multiple values of another cell. For example, cell L5 has a list of three words (emergency, urgent, routine) and I want to highlight E5 red if emergency is selected and E5 has a value of more than 2 (days). E5 shows the number of days elapsed from two other cells. Then, if urgent is selected from L5, and E5 is greater than 14, highlight E5 red. Same with routine if E5 is greater than 365. If E5 is less than those numbers, highlight in green. I have to do this for E5 and L5 thru E632 thru L632. I have tried using conditional formatting with no avail. I have attached a copy of my spreadsheet. Any help would be greatly appreciated.