Can a formula contain an action?
 

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!

Can a formula contain an action?
 

You could use conditional formatting, which supports strikethrough.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Peggy" wrote in message
...
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!

Can a formula contain an action?
 

Ok, would that be an if, then statement?

"Bob Phillips" wrote:

You could use conditional formatting, which supports strikethrough.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Peggy" wrote in message
...
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!

Can a formula contain an action?
 

Conditional formatting is accessed by the menu FormatConditional Formatting...

--
Regards,
Fred


"Peggy" wrote in message
...
Ok, would that be an if, then statement?

"Bob Phillips" wrote:

You could use conditional formatting, which supports strikethrough.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Peggy" wrote in message
...
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!

Can a formula contain an action?
 

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

"Fred Smith" wrote:

Conditional formatting is accessed by the menu FormatConditional Formatting...

--
Regards,
Fred


"Peggy" wrote in message
...
Ok, would that be an if, then statement?

"Bob Phillips" wrote:

You could use conditional formatting, which supports strikethrough.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Peggy" wrote in message
...
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!

Can a formula contain an action?
 

"Peggy" wrote:
... a formula to match two numbers from two colums
.. I want to strikethrough both numbers if there is a match.
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:
http://www.savefile.com/files/1645577
Cond Format Matching Nos in 2 Cols_Peggy_misc.xls

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

Now do the converse for col B

Select col B
Click Format Cond Formatting
Under Condition1, make the settings as:
Formula is: =AND(ISNUMBER(MATCH(B1,A:A,0)),B1<"")
Click Format button Font tab Strikethrough 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
http://savefile.com/projects/236895
xdemechanik
---

Can a formula contain an action?
 

YES! That is so it!!!! Thank you Thank you Thank you!

"Max" wrote:

"Peggy" wrote:
... a formula to match two numbers from two colums
.. I want to strikethrough both numbers if there is a match.
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:
http://www.savefile.com/files/1645577
Cond Format Matching Nos in 2 Cols_Peggy_misc.xls

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

Now do the converse for col B

Select col B
Click Format Cond Formatting
Under Condition1, make the settings as:
Formula is: =AND(ISNUMBER(MATCH(B1,A:A,0)),B1<"")
Click Format button Font tab Strikethrough 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
http://savefile.com/projects/236895
xdemechanik
---

Can a formula contain an action?
 

You're welcome !
Thanks for the feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Peggy" wrote in message
...
YES! That is so it!!!! Thank you Thank you Thank you!