Thanks Tushar, this helped a lot! Now I am having an issue with the nulls. I managed to change them all to N/A in my table, but I cannot figure out a way to remove the color. When I use the exclude nulls Tableau removed the entire row. Any ideas on how to remove the color from the fields with no values?
Sorry for the late reply. You can try editing the color legend advance properties where you can set start and end for each color.
Check this thread to get some idea where Shin talks about it.