I'm trying to create a cell condition (that can be copy/pasted down a column as needed - on a master sheet atm) - the condition is this:
If Cell X (next to cell being conditioned) has text PARTY!, then display "Y". Otherwise leave blank (for users own input). Cell X is a dropdown menu cell with...