I made a sheet with shaded cells based on a value that I calculated. Instead of using a gradient for the color, I wanted to create categories, but as soon as I put those categories into he color box, the shaded cells turned into squares.