need 4 conditions for conditional formatting and there are only 3
 

I am working with results from DNA screens using vlookup. So my return
values will be A, C, T, G, 0 (for no result), or the #N/A error. Is there
any way for me using conditional formatting to say if the cells do not equal
A,C,T, or G, then apply my format?

Thanks in advance.

need 4 conditions for conditional formatting and there are only 3
 

Check Ron's page out

http://www.rondebruin.nl/easyfilter.htm
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"pm" wrote:

I am working with results from DNA screens using vlookup. So my return
values will be A, C, T, G, 0 (for no result), or the #N/A error. Is there
any way for me using conditional formatting to say if the cells do not equal
A,C,T, or G, then apply my format?

Thanks in advance.

need 4 conditions for conditional formatting and there are only 3
 

Select your range
In this case I use column A
Adjust to suit your needs

Conditional Formatting
Condition 1 : =AND($A1<"A",$A1<"C",$A1<"T",$A1<"G")
Format your color

Condition 2 : =ISERROR($A1)
Format the same color as condition 1



"pm" wrote:

I am working with results from DNA screens using vlookup. So my return
values will be A, C, T, G, 0 (for no result), or the #N/A error. Is there
any way for me using conditional formatting to say if the cells do not equal
A,C,T, or G, then apply my format?

Thanks in advance.