Conditional Formatting Help-ome light on what I'm doing wrong

Hey all. Hoping that someone can shed some light on what I'm doing wrong here. I've tried everything I can think of and can't get the results I desire.

In the attached spreadsheet, I've got several transactions that I want the cell background changed based on whether they meet the following criteria:

IF $M2<Today()

AND $I2="Auto" or $I2="Home"

So basically, if the date in column M for each row is less than today's date, and the data in column I equals either Auto or Home, I need it to change the background color of the cell.

I've tried combining multiple formulas in the conditional formatting tool and can't get where I need to be. I can get it to highlight everything based on the date, or whether it's Auto or Home, but not in a way that the Date and the Auto/Home criteria are met. If the date is less than today, but the contents of say I5 is UMB, I don't want any formatting to take place.

Is this even possible, or am I just dreaming?

Try this

select formula is

=OR(AND(M2<TODAY(),I2="Auto"),AND(M2<TODAY(),I2="Home"))

Select the formatting you want

Ed

Works great with a little tweaking to make it highlight the entire row. You folks are AWESOME! Thanks so much!

Glad to help - thanks for the feedback.

Ed