To illustrate, here I have a list of projects representing a sales pipeline. However, as a workaround, you can define named a named range that points to a table, and then use the named range for data validation or conditional formatting. One problem with tables is that you can't use structured references directly to create data validation or conditional formatting rules. In this video, we'll look at how to use named ranges with Excel tables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |