Conditional Formatting

[Guest]

Here is my request. I have a form with a drop down menu
of 4 items. I am trying to write a formula (not code) for
the following action:

=IIF[Classification]="Protected B", [Name]= (Colour of
font will be white). I don't seem to be able to make it
work. I am always missing something.

What I really want is that some field would look like
empty if the classification is Protected B.

Can anyone help me on that formula^

Thanks a bunch

 

[mzehr]

Hi,
maybe as an alternative you could check out
Data Validation -- Create Dependent Lists
http://www.contextures.com/xlDataVal02.html
Debra does an excellent job of walking you through how to
only have certain items appear in your list based on
previous selections.