I changed the range in my spreadsheet to an Excel List. Now, when I add a new item, the conditional formatting is not extended down from the previous row. Is there a way to make the list pick up the formatting? If I convert the list back to a range, it works as I intend. Likewise, if I type the new entry UNDER the list, the formatting works. Thanks!

And sorry if this has been addressed before. I had no luck limiting a search to manageable size to skim the answers.

--Karyl