I have a cell that I need to apply 4 different conditional formats to
and as you know excel only allow 3.

Within conditional formating you can choose cell or formula, I am
using Formula is =(Q7="Yes") which turns the cell red. This works
fine.

What I need to know is can I add an extra option within the formula
thus giving me more than the 3 conditional formats ie =(Q7="Yes","N/
A") to turn cell red