I'm using the list in conditional formatting for a dropdown list of tooling (Excel 2007). I identified a range and assigned it the name "Toolinglist" I now have tools that I need to add to that list and therefore need to establish a larger range.



How do I expand the range for "Toolinglist" without renaming it and changing all the references to it in my workbook?