I have a spreadsheet with several cells in one column. Each cell has identical conditional formatting:
- In 1 cell value equal to
- In 2 cell value equal to
- 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?