Toby Lawler on 25 Jan 2023 00:03:54
When a cell has conditional formatting applied, the consumer is often left wondering what it means. For instance, an exclamation point icon next to a value gets the consumers attention, but they need a legend or prior instruction of some kind to interpret the exact meaning. Except for mobile users, hovering the cursor over the icon (or colored text, etc.) and having a custom tooltip appear would be an elegant solution. The current tooltip feature could remain as is but would be overridden when the conditional formatting in the cell was active.