RE: [PCTECH] Excel ?

[Mark Allen <mallen@xxxxxxxx>]

ColB had conditional formatting that said make it red if not = to columna A

Mark Allen
IS Manager
Wilkes Telephone & Electric
11 W. Court Street
Washington, GA 30673
Phone: (706) 678-9565
Cell: (706) 498-7907
Fax: (706) 678-1000


-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx] On
Behalf Of Alan
Sent: Saturday, May 15, 2004 12:33 PM
To: PC Technical Discussion for iSeries Users
Subject: Re: [PCTECH] Excel ?


Did I miss somethihng in this conversation Mark? I thought this had to 
do with the rows being in color?

O does this mean that the colors were there related to this formula?

- Alan


Mark Allen wrote:

>Col A      Col B         Col C
>XYZ        XYZA          Formula if a=b then 0 else 1
>
>Then turn on auto filter in C and select only those values=1 Cut and 
>paste to another sheet and print
>
>Mark Allen
>IS Manager
>Wilkes Telephone & Electric
>  
>

_______________________________________________
This is the PC Technical Discussion for iSeries Users (PcTech) mailing list
To post a message email: PcTech@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/pctech.