Compare value in last cell of column to another cell in other column

[skyport]

How can I take a column that contains dates (column E) that continues to have more dates added and then have the last cell in that column (E) be filled with red using conditional formatting, ONLY if the value of that last cell in Column E is less than the value I have in cell H1 otherwise, that last cell in E would stay normal with out change

 

[RonB1111]

1. Select Column E
2. Click Home - Conditional Formatting - New Rule
3. Click "Use a formula to determine which cells to format"
4. Enter this formula in the box below the words: "Format Values where this format is true"

=AND(E1<>"",E2="",E1<H$1)

5. Click the Format icon, go to Fill tab and click on a red color, then OK, OK

 

[skyport]

thanks so much for helping me. I tried the formula but it fills the last cell in column E regardless of whether it's value is less or greater than cell H1. What I need it to do is only fill with color if the last cell in E is less in value than the value that sits in cell H1 or H1 greater than the value in last cell of column E.

 

[RonB1111]

The last part of the formula got cut off and I didn't catch it when I posted. Here's the complete formula:
=AND(E1<>"",E2="",E1<h$1)<h$1)[ code]<="" html=""><h$1)< h$1)<h$1)[=""> < H$1)</h$1)<></h$1)<h$1)[>

 

[skyport]

Perfectly well done - works like a charm now. thanks so very much. this forum has been so great and responders like yourself are of great value to the community. We are so grateful.

 

[RonB1111]

You're welcome!