I have a table that consists of around 150 cells. I would like to have a cell, separate from the table, that contains a drop down menu, and from the drop down menu are choices that control the conditional formatting applied to the table. So for example, the drop down menu would have 3 options: highlight green only cells <1 or highlight blue all cells <5, or black out all cells between 0 and .5.
Bookmarks