Hi

I am trying to change another cell based upon a pull down box selection and
cant get the IF statement to 'fire' on the second cell.

Is there a way to automatically do this or can you suggest another simple
method?

Any help would be appreciated.