Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |