Forum Discussion

danz120488's avatar
danz120488
Copper Contributor
Aug 28, 2020
Solved

IF function for cells with strikethrough

Hi all,

 

I wonder if anyone here would know how to do this. As per the subject, I happen to have a couple cells with strikethrough that I need to use in an IF function. The argument should be:

 

If cell X has a strikethrough, I want the formula to return A, otherwise (if false) then it should be B.

 

Thanks and regards,

 

Daniel

Formulas and Functions
  • Ramiz_Assaf's avatar
    Ramiz_Assaf
    Aug 28, 2020

    danz120488 

    this has been answered in another forum 

    here is the link

     

    https://social.msdn.microsoft.com/Forums/en-US/b6f87e3c-fe87-4843-909d-a7ef6d2991e8/vba-excel-to-determine-if-a-partial-strikethrough-of-text-in-a-cell-is-true?forum=exceldev

     

    I implemented it for you in the following sheet

     

     

2 Replies

  • Ramiz_Assaf's avatar
    Ramiz_Assaf
    Iron Contributor
    Aug 28, 2020

    danz120488 

    this has been answered in another forum 

    here is the link

     

    https://social.msdn.microsoft.com/Forums/en-US/b6f87e3c-fe87-4843-909d-a7ef6d2991e8/vba-excel-to-determine-if-a-partial-strikethrough-of-text-in-a-cell-is-true?forum=exceldev

     

    I implemented it for you in the following sheet

     

     

Resources