Trismos
New member
- Joined
- Jun 25, 2013
- Messages
- 5
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2013 and 2016
Hello
I have a report where one cell has a question and the following cell has a drop down menu that includes YES, NO, and N/A
I would like the cell with the question to be grayed out if the answer is N/A. Can this be done with conditional formatting or is there another way?
Thx
Dave
I have a report where one cell has a question and the following cell has a drop down menu that includes YES, NO, and N/A
I would like the cell with the question to be grayed out if the answer is N/A. Can this be done with conditional formatting or is there another way?
Thx
Dave