View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default 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!