
New Member

December 16, 2018

Hi,
I choose "pattern fill" for my data series formatting. For the "foreground" I choose "red" color. I notice that , for "Invert if negative", Excel doesn't let me to choose another color and keep the same pattern like it does if I would have chosen "Solid fill".
Any workaround for this problem? For invert if negative I want to keep the same pattern, but to able to change the color.
Thanks in advance!

VIP

Trusted Members

June 25, 2016

Hi Radu
Not too clear about your formatting requirement. Is it using same patterns with different colors for positive and negative?
See if this is helps. I have created 2 series and filled them with patterns.
Otherwise maybe you can share with us your file with your expected result.
Sunny
1 Guest(s)
