Forum Discussion
Solved
If Function help
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 doesn...
Thanks Sergei, almost works. I am trying to conditionally format the formula cell to go red when the result is blank. However the result is not blank. This may be becaue a6:a8 is NO as a result of a dropdown rather than inputting "NO"
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.
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.