Formula to search for a value in a range of cells
Posted
by
Sacha
on Super User
See other posts from Super User
or by Sacha
Published on 2012-10-17T16:13:28Z
Indexed on
2012/10/17
17:05 UTC
Read the original article
Hit count: 208
microsoft-excel
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?
© Super User or respective owner