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.

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.

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.