Mar 14 2021 09:44 AM - edited Mar 14 2021 11:14 AM
Hi,
I am trying to create a formula which will return blank if cells a6:a8 are all NO, and to display cell b6 if this isn't correct. See attached spreadasheet. I have a formula below but it doesnt work:
=IF(AND(A6:A8="NO","",B6)))
Mar 14 2021 10:11 AM - edited Mar 14 2021 11:01 AM
SolutionMar 14 2021 10:39 AM
Mar 14 2021 11:07 AM
For the conditional formatting most probably it shall be another formula, but I didn't catch the logic - you would like to highlight something if ALL in range A6:A8 are "NO"; or you'd like to highlight for each record where the value in column A is "NO".
Perhaps you may provide small sample colored manually to illustrate the idea.
Mar 14 2021 11:13 AM - edited Mar 14 2021 11:15 AM
Yes I have attached what I am trying to do I have added conditional formatting in c6, and would like this to be red when one of the dropdown boxes between a6:a8 is a yes rather than a no.
Mar 14 2021 11:28 AM
Mar 14 2021 11:32 AM
Mar 14 2021 11:36 AM
You are welcome. That could be done by several ways, depends on your actual data and which approach is more comfortable for you from maintenance point of view.
Mar 14 2021 10:11 AM - edited Mar 14 2021 11:01 AM
SolutionOn which Excel you are?
If correct the syntax
=IF(AND(A6:A8="NO"),"",B6)
formula works