I'm trying to change a row colour when an exact date is specified in a cell.
I've tried using conditional formatting, stating the range of the cells (A2:M2) that need to be highlighted green should a specific date be selected in a cell (L2). All that is happening, though, is the cell that contains the date is being highlighted rather than the entire row.
The overall intention is for an entire row to be highlighted a different color when a specific date is selected (L2). The same logic will be applied to all cells below L2.