Hi

If - Then is a logic based, hence therefore if your selection is not
Black, then it is something else in your logical list.

I think the use of a Dependent Data Validation List is most likely a
better option which you could then expand into:

Male, Female
Style
Heel
Color
Size.

Check this link out, it gives you a step-by-step on how to set it up.

http://www.contextures.com/xlDataVal15.html

I use this version to great success, albeit for a different purpose.

There are a few other variation on Debra's site that may also suit.

HTH
Mick.