Conditional formatting IF

Sorry - like I said I'm new :-) I didnt see the option to add a file (only an image). Here you go
Example.xlsx
This is a sample of the data (its a simplified version of a much larger spreadsheet I am working on).

I realize this should be straight forward...I just have a mental block for some reason.

Okay, well you will learn more if you actually do it yourself, so follow the instructions above and use this formula:

=AND(E$1<TODAY(),$D2="no")

and choose red for the background. Note that you only have two conditions within the AND function this time, separated by a comma, whereas for the other formulae there were 3. Note also where the $ symbols are in the formula (and the previous ones) - these prevent that part of the cell reference from changing when the formula is applied in other cells, so basically we want to compare the date which is always on row 1, and compare the contents of column D always.

Hope this helps.

Pete