software

Ok, I have a formula to match two numbers from two colums and then to give me
a reference line for the second number (MATCH(A2,C:C,0))

Now I want to strikethrough both numbers if there is a match. If there is
not a match then there would be no strikethrough. I am not sure if this is
an action, or if it would be a format command. Or if it can even be done.

Any help would be greatly appreciated,

Thanks for any response!

You could use conditional formatting, which supports strikethrough.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Peggyquot; gt; wrote in message
...
gt; Ok, I have a formula to match two numbers from two colums and then to give
me
gt; a reference line for the second number (MATCH(A2,C:C,0))
gt;
gt; Now I want to strikethrough both numbers if there is a match. If there is
gt; not a match then there would be no strikethrough. I am not sure if this
is
gt; an action, or if it would be a format command. Or if it can even be done.
gt;
gt; Any help would be greatly appreciated,
gt;
gt; Thanks for any response!
Ok, would that be an if, then statement?

quot;Bob Phillipsquot; wrote:

gt; You could use conditional formatting, which supports strikethrough.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Peggyquot; gt; wrote in message
gt; ...
gt; gt; Ok, I have a formula to match two numbers from two colums and then to give
gt; me
gt; gt; a reference line for the second number (MATCH(A2,C:C,0))
gt; gt;
gt; gt; Now I want to strikethrough both numbers if there is a match. If there is
gt; gt; not a match then there would be no strikethrough. I am not sure if this
gt; is
gt; gt; an action, or if it would be a format command. Or if it can even be done.
gt; gt;
gt; gt; Any help would be greatly appreciated,
gt; gt;
gt; gt; Thanks for any response!
gt;
gt;
gt;

Conditional formatting is accessed by the menu Formatgt;Conditional Formatting...

--
Regards,
Fredquot;Peggyquot; gt; wrote in message
news
gt; Ok, would that be an if, then statement?
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt;gt; You could use conditional formatting, which supports strikethrough.
gt;gt;
gt;gt; --
gt;gt; HTH
gt;gt;
gt;gt; Bob Phillips
gt;gt;
gt;gt; (remove nothere from email address if mailing direct)
gt;gt;
gt;gt; quot;Peggyquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Ok, I have a formula to match two numbers from two colums and then to give
gt;gt; me
gt;gt; gt; a reference line for the second number (MATCH(A2,C:C,0))
gt;gt; gt;
gt;gt; gt; Now I want to strikethrough both numbers if there is a match. If there is
gt;gt; gt; not a match then there would be no strikethrough. I am not sure if this
gt;gt; is
gt;gt; gt; an action, or if it would be a format command. Or if it can even be done.
gt;gt; gt;
gt;gt; gt; Any help would be greatly appreciated,
gt;gt; gt;
gt;gt; gt; Thanks for any response!
gt;gt;
gt;gt;
gt;gt;
Right, I can't get it to strikethrough the two numbers. Only the number
(that tells me the line that the number in A matches a number in C) in the
cell that the forumula is in. There must be a way I just can't figure it out.

Thanks for all your help,

Peggy

quot;Fred Smithquot; wrote:

gt; Conditional formatting is accessed by the menu Formatgt;Conditional Formatting...
gt;
gt; --
gt; Regards,
gt; Fred
gt;
gt;
gt; quot;Peggyquot; gt; wrote in message
gt; news
gt; gt; Ok, would that be an if, then statement?
gt; gt;
gt; gt; quot;Bob Phillipsquot; wrote:
gt; gt;
gt; gt;gt; You could use conditional formatting, which supports strikethrough.
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; HTH
gt; gt;gt;
gt; gt;gt; Bob Phillips
gt; gt;gt;
gt; gt;gt; (remove nothere from email address if mailing direct)
gt; gt;gt;
gt; gt;gt; quot;Peggyquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Ok, I have a formula to match two numbers from two colums and then to give
gt; gt;gt; me
gt; gt;gt; gt; a reference line for the second number (MATCH(A2,C:C,0))
gt; gt;gt; gt;
gt; gt;gt; gt; Now I want to strikethrough both numbers if there is a match. If there is
gt; gt;gt; gt; not a match then there would be no strikethrough. I am not sure if this
gt; gt;gt; is
gt; gt;gt; gt; an action, or if it would be a format command. Or if it can even be done.
gt; gt;gt; gt;
gt; gt;gt; gt; Any help would be greatly appreciated,
gt; gt;gt; gt;
gt; gt;gt; gt; Thanks for any response!
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

quot;Peggyquot; wrote:
gt; ... a formula to match two numbers from two colums
gt; .. I want to strikethrough both numbers if there is a match.
gt; If there is not a match then there would be no strikethrough.

Assuming the numbers are in cols A and B,
here's a way to conditionally format it ..

A sample construct is available at:
www.savefile.com/files/1645577
Cond Format Matching Nos in 2 Cols_Peggy_misc.xls

Select col A
Click Format gt; Cond Formatting
Under Condition1, make the settings as:
Formula is: =AND(ISNUMBER(MATCH(A1,B:B,0)),A1lt;gt;quot;quot;)
Click Format button gt; Font tab gt; Strikethrough gt; OK
Click OK at the main dialog

Now do the converse for col B

Select col B
Click Format gt; Cond Formatting
Under Condition1, make the settings as:
Formula is: =AND(ISNUMBER(MATCH(B1,A:A,0)),B1lt;gt;quot;quot;)
Click Format button gt; Font tab gt; Strikethrough gt; OK
Click OK at the main dialog

Note that it could be difficult to distinguish visually
the strikethrough for certain numbers, eg: the numbers: 4, 44, ...
so you might want to set it to conditionally format
the cell fill to trigger as well (Patterns tab)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
YES! That is so it!!!! Thank you Thank you Thank you!

quot;Maxquot; wrote:

gt; quot;Peggyquot; wrote:
gt; gt; ... a formula to match two numbers from two colums
gt; gt; .. I want to strikethrough both numbers if there is a match.
gt; gt; If there is not a match then there would be no strikethrough.
gt;
gt; Assuming the numbers are in cols A and B,
gt; here's a way to conditionally format it ..
gt;
gt; A sample construct is available at:
gt; www.savefile.com/files/1645577
gt; Cond Format Matching Nos in 2 Cols_Peggy_misc.xls
gt;
gt; Select col A
gt; Click Format gt; Cond Formatting
gt; Under Condition1, make the settings as:
gt; Formula is: =AND(ISNUMBER(MATCH(A1,B:B,0)),A1lt;gt;quot;quot;)
gt; Click Format button gt; Font tab gt; Strikethrough gt; OK
gt; Click OK at the main dialog
gt;
gt; Now do the converse for col B
gt;
gt; Select col B
gt; Click Format gt; Cond Formatting
gt; Under Condition1, make the settings as:
gt; Formula is: =AND(ISNUMBER(MATCH(B1,A:A,0)),B1lt;gt;quot;quot;)
gt; Click Format button gt; Font tab gt; Strikethrough gt; OK
gt; Click OK at the main dialog
gt;
gt; Note that it could be difficult to distinguish visually
gt; the strikethrough for certain numbers, eg: the numbers: 4, 44, ...
gt; so you might want to set it to conditionally format
gt; the cell fill to trigger as well (Patterns tab)
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt;
gt;
gt;

You're welcome !
Thanks for the feedback ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Peggyquot; gt; wrote in message
...
gt; YES! That is so it!!!! Thank you Thank you Thank you!