I'm trying to set up conditional formatting to color the entire row based on the information in a range of cells. I can get it to work based on one cell, but am having trouble with more than one cell reference. Here is what I can get to work:
The information in cell AL4 is a date, and I have various dates in the cell range of AL4:AL30. I need it to color the row if the date equals ANY of the dates in the range. The dates are always changing, and they are not consecutive so I can't use a static date range.
Any help is much appreciated.