If (condition1) AND (either condition 2 3 or 4)

Originally Posted by DonkeyOte

EDIT: though it might help if I actually referenced the correct cells !

Lol yeah I did change that, tis ok.

Thats strange then, maybe its something to do with excel saying at the top 'compatability mode'? Thats the only thing I could think of!

Sorry the screenshot is a gif (and why does it think its a jpg :S ) but it was too big to upload as a jpg or png