Highlight Cells which are After the Date in Cell with Red Once Date is reached

I need my Spreadsheet to be highlighted Red J under Status once Date on column I is reached.
Since I run events from From Start Date to End Dates and would need to know once event End date is reached, it will automatically turn red and i can delete off spreadsheet.

I have attached a Spreadsheet for your reference.

Appreciate any help!!!

Set up a rule in Conditional Formatting =TODAY()>=I2 Then use Format painter to apply the rule to needed cells. See example attached

This is great, Thanks a milion!!

Why are empty cells being highlighted red when nothing filled in and conditional formatting is applied to whole row, Would I be able to prevent that since i would like it to be for whole row instead of going back and forth to conditional formatting.

Please help, I appreciate your time!

Why are empty cells being highlighted red when nothing filled in and conditional formatting is applied to whole row, Would I be able to prevent that since i would like it to be for whole row instead of going back and forth to conditional formatting.

Please help, I appreciate your time!

Look again at the formula =TODAY()>=I2

It states that todays date is bigger or equal to the date in the cell I2. Now, if the cell is empty, how does that affect the formula?

If you select an empty cell, format it as date and write in the number 0 (zero) this is what you get 00.01.1900 so if the cell is empty, Excel probably treats it as 00.00.1900 or something like that, meaning that todays date will always be bigger than the default date value, and the rule of Conditional formatting will apply.

Solution? Only apply the rule to cells and areas with actual values by using Format painter.