I have a spreadsheet with several cells in one column. Each cell has identical conditional formatting:

- In 1 cell value equal to
`='Y'`

- In 2 cell value equal to
`='N'`

- In 3 cell value equal to
`='?'`

What I would like to achieve is, if all 7 cells contain "Y" as the option then a separate cell will display "Yes", but if any of the cells contain "N" as the selection then the separate cell will display "NO".

How can I achieve this?