Anyone have a suggestion on how to use the morse conditional formatting to signify both negative and positive values are significant?
Issue I have is that if I have:
-50%, 0, 50%
CF -1 (red), 0 (white), 1 (green)
The problem I have is that -50% shows as a red dot, whereas 50% shows as a significant line. I want -50% to be a significant red line, and 50% being a significant green line. Absolute doesn't work, because it's still a range.
Otherwise, also interested in other ways of creatively showing this -- keep in mind that it's going on a management reporting page (meaning that images can't be used as it's for multiple line items in a chart).