Hi!
I am aware of a number of ways to use Conditional Formatting Icon Sets based on text in a different cell. Even how to display text in a cell along with an Icon based on a text or value entered elsewhere (with a Custom Format).
However, how can one show an Icon as a result of text (maybe/maybe not controlled via a Data Validation [drop down] List) entered into the SAME cell? I.e. functionally identical to what happens when entering a number in to cell with Conditional format Icon Sets of Type: Number.
The Type: Formula does not allow reference formulas (to for example go do an INDEX MATCH... to assign a numeral value to a text string in a named Array) which one could then use to choose the desired icon based on a value.
Or even create the illusion that is what is happening by having a ‘results cell’ display in the same spot as the ‘entry cell’. Even, if necessary, using a hidden ‘helper’ cell.
(This in Office 365 ProPlus)
Ideas? Thanks!
Bookmarks