STRIKE THROUGH

Question

Q: STRIKE THROUGH

I HAVE A NUMBER OF EXCEL CELLS (A1:A4)WITH THE LETTER X.

SOME OF THE X HAVE A STRIKE THROUGH X.

I WANT CONDITIONAL FORMATING TO HIGHLIGHT CELLS WITH  X CHARACTER.

Answer 1

Use this UDF in Conditional Formatting.

Function HasStrike(Rng As Range) As Boolean

Application.Volatile

      HasStrike = Rng.Font.Strikethrough

End Function

In CF select the range of cells then use a formula  =HasStrike(cellref)

UDF needs to be stored in regular module in your workbook.

Gord

Answer 2

With your workbook open hit Alt + F11 to go to Visual Basic Editor.

CTRL + r to open Project Explorer if you don't see it.

Select your workbook/project and right-click>insert>module.

Paste the UDF into that module.

Alt + q to return to the Excel window.

In CF select A1:A10 then use a formula  =HasStrike(A1)

Gord

Answer 3

I need a step by step guidance of what to be done.

Answer 4

Do I use VBA i.e ALt 11 , Insert Module and paste:

Function HasStrike(Rng As Range) As Boolean

Application.Volatile

      HasStrike = Rng.Font.Strikethrough

End Function

?

Answer 5

Can you guide me step by step using the following example:.

Cell A2 has the strike through. I what conditional formatting to detect the strike through.

What is the nest step?

A<br><br><br>1x
2x