Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I test in a formula if my font is strikethrough or not?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I test in a formula if my font is strikethrough or not?
You could do this with VBA.
To test cell A1: Sub StrikethoughTest() If Range("A1").Font.Strikethrough = True _ Then MsgBox ("Cell A1 is using Strikethrough.") Else MsgBox ("Cell A1 is NOT using Strikethrough.") End If End Sub To test the active cell: Sub StrikethoughTest() If ActiveCell.Font.Strikethrough = True _ Then MsgBox ("Cell " & ActiveCell.Address & " is using Strikethrough.") Else MsgBox ("Cell " & ActiveCell.Address & " is NOT using Strikethrough.") End If End Sub HTH, Paul "JFD_TP" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to test a cell for the strikethrough effect? | Excel Discussion (Misc queries) | |||
Calculate mean of test scores from rows of test answers | Excel Discussion (Misc queries) | |||
If statement to test font color | Excel Discussion (Misc queries) | |||
Count cells with strikethrough font? | Excel Worksheet Functions | |||
Strikethrough and Underline Font Macro | Excel Worksheet Functions |