Help with Conditional formatting

Lindsay,

It looks like the format painter was still referencing column A, and the last two were missing the <.  I've corrected the formulas, and also added a rule to handle blank cells.  I've taken the liberty of adding a sheet to your workbook, and copying your info to a table.  This is an instance that I would recommend using a table for your data, because the conditional formatting 'Applies to' section will grow and shrink as rows are added and removed.  If you press tab in the bottom right cell of the table, it will automatically add a new row, and extend the formatting, and any column formulas you may use to the next row.  Just something to consider, and if you decide not to use it, you can just delete the tab that says Table Version