Results 1 to 1 of 1
2005-09-12, 16:51 #1
- Join Date
- Jul 2004
- Sumner, Washington, USA
- Thanked 0 Times in 0 Posts
Conditional Formatting in List (Excel 2003)
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.