cell condition question for Google Sheets

[Resika]

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 a list of Left, Right, and PARTY!. The conditioned cell is a Y/N cell for user to enter their yes/no answer, although if Cell X is PARTY! then the answer is a default Y.

I will condition the cell again to be green if Y or Red if N (which I'm pretty sure I can figure out after I get this condition down!)

Thank you!

 

[Scott Huish]

Most people here, including myself, would be able to answer this question for Excel, not Google Sheets, as this is an Excel forum.

Google has a forum pertaining to their products, which may be more helpful, if you are not actually using Excel.

https://productforums.google.com/forum/#!topicsearchin/docs/category$3Aspreadsheets%7Csort:relevance%7Cspell:false

 

[Resika]

Oh, thank you! I kept finding just random help things instead of the actual forum? I didn't know if it would be similar enough for this forum to answer! Thanks a bunch!