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

You can have this as your CF formula:

=OR(Q7="Yes",Q7="N/A")

but that only counts as one CF condition, so you are not really
getting 4 CFs.

Hope this helps.

Pete

On Mar 31, 10:29*am, Paul wrote:
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