Hi All,
I'm trying to conditional format cells containing percentages so that the highest positive percent will be the brightest green fill and the lowest negative number will be the brightest red fill. However, I only want negatives to be filled with red and positives to be filled with green with zero being filled with white.
I hope this makes sense. I tried conditional formatting using a color scale with red to green, but it just goes lowest to highest. If all of your numbers are positive, it will color positive cells red, which I think could be a little confusing.
Any help would be greatly appreciated.
Thanks
Bookmarks