floggingmolly
Board Regular
- Joined
- Sep 14, 2019
- Messages
- 167
- Office Version
- 365
- Platform
- Windows
I have a workbook that has several columns with questions. For example if they answer NO in column A that is a red flag. But if they put an explanation in column B then its not a red flag. There are multiple columns with this scenario. I am trying to make a formula that basically says if A = NO and B has any text then its OK, other wise its a red flag, and the same for Columns C and D, E and F, G and H. Not sure if this makes any sense or if this can be done without helper columns. Any help would be appreciated.