Colorblind artists prevail! It's comforting to know there are a lot of great artists who are colorblind.
I was really depressed a few years back when I feared I was color blind and when I finally got it confirmed at a doctor I felt really miserable, luckily I didn't let it stop me because I love design and art..
And it's only color deficiency, I can see red/green fine unless it's low saturation or very dark.
Also having digital tools that can tell the exact RGB values help. I sometimes mix up dark brown and dark green, so I'm extra careful with those colors.
Something that is quite annoying though is that certain colors like neon orange next to dark blue is hard for me to focus on, especially light ( like from a monitor) also some colors on alarm clocks. which look fuzzy.
edit [Something I've noticed when playing LoL, the purple text is hard to focus on for me, it doesn't look as sharp as other colors, not sure if it's color deficiency or the fact that I have glasses, because I doubt the designers who chose purple have the same issue. (also why did they choose blue/purple and not red/blue? Purple still contains blue so it's not the best opposite match)
http://i.snag.gy/EoCEu.jpg]
It does lower your confidence somewhat as an artist, knowing you can never have perfect color vision, but for me this is all I have so it's good enough.
I just have to read up more on colors and color theory to know what to avoid and be careful with.
@Dusty
I find that dark yellow looks very green..
I thought it was due to my color deficiency, but maybe it's like that for everyone? I just tend to make the shadows more red.