I want to make rows that have passed their deadline red. That is all I want to do. However, when I open the conditional formatting screen, there are options like "Highlight Cells Rules," "Top/Bottom ...

On Monday morning, the summary sheet was "broken" This happened three years ago at a manufacturing client's site. In the order management Excel file I designed, I had implemented "Data Validation" to ...