|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
