To clear the rule, repeat steps 1 through 2 above. When this happens, clear the icon set format because it'll show up later when you reference the formatted values. That's because the TRUE and FALSE values are text. Choose Icon Sets and select an icon set.ĭon't be surprised when nothing seems to happen.For this example, that's L2:L46 (the TRUE and FALSE values). When the product has been discontinued, the value is TRUE. It's a bit counter-intuitive, but that's one of the challenges.įirst, let's try Excel's easiest icon-displaying solution: This "discontinued" value is FALSE when the product hasn't been discontinued, meaning it's available. The data contains a column of text values that represent whether the company still sells the product. You can work with any data you like, but the Products data presents some interesting challenges. To demonstrate this feature, I'll work with data I imported from the Products table in the Northwind database that comes with Access.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |