I have a slightly unusual situation with the conditional formatting in one of our waterfall charts. Currently it is possible to select a conditional format for negative numbers and a different one for positive numbers. We have a situation where we are moving from a baseline to a target and therefore negatives are good (formatted green). However, there is a final sum which shows "gap to target" which is effectively how much under or over the target they are. If they are under target this shows as a negative and therefore green, even though its actually a "bad" thing and should show as red. Conversely if they've met their target it then shows red....any one have any suggestions how this can be got around?
Thanks
Matt