Ctrl+5

R

Rick Rothstein

I don't think so. The Strikethrough (what you are calling "cross out line") is an attribute of the font itself (just like bold is) and not a separate entity, so I don't believe it can have a different color than the text it is applied to. If you click Format/Cells on the menu bar and click the Font tab on the dialog box that comes up, you will see Strikethrough in the Effects section... there is no color options for it... the only color option available is for the entire font.
 
L

Lerner

Thank you.

Rick Rothstein said:
I don't think so. The Strikethrough (what you are calling "cross out line") is an attribute of the font itself (just like bold is) and not a separate entity, so I don't believe it can have a different color than the text it is applied to. If you click Format/Cells on the menu bar and click the Font tab on the dialog box that comes up, you will see Strikethrough in the Effects section... there is no color options for it... the only color option available is for the entire font.
 
S

Shane Devenshire

Hi,

Neither of these solutions are very good, but you never know...

In 2007, if you choose Word Art you can draw the strikeout through the
middle of the text. The line will attach to the vertical midpoint of the
text box. The line can be colored any color.

In 2003 you can add a flowchart rectangle and attach a connector to its mid
points, then color the connector and select the edge of the rectangle and
choose Format AutoShape, select the Colors and Lines tab and choose No Line
for Line Color and None for Fill Color.
Hold down the Alt key and drag the rectangle over the cell where you want
strikethrough. This will get it to snap to grid. Resize the shape using the
Alt key to get it to fit exactly in the cell. Resize the column width to
match the text length.
 
Top