+ Reply to Thread
Results 1 to 2 of 2

Counting cells with conditional formatting generated strikethrough text

  1. #1
    Registered User
    Join Date
    10-10-2016
    Location
    Coimbra, Portugal
    MS-Off Ver
    2016
    Posts
    86

    Counting cells with conditional formatting generated strikethrough text

    Hi.
    I need to count a range cells that have text:

    1. stricken through conditional formatting
    2. normal non-stricken text.

    I'm asking for help in the VBA section because I assume that it can't be done without VBA.
    I've been browsing the web and all the VBA code out there only counts cells that are manually formatted.
    By the way, I don't just have a single conditional formatting rule but multiple ones that strikethrough text in different colors.
    Any help is appreciated.
    Thank you.

    PR
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,562

    Re: Counting cells with conditional formatting generated strikethrough text

    Here is a low tech, formula based proposal.
    List the four conditional formatting rules in four columns adjacent to the table.
    A fifth column, headed Strikethrough is populated using: =OR(U10=TRUE,V10=TRUE,W10=TRUE,X10=TRUE)
    The count if rows that contain strikethroughs (cell I4) is populated using: =COUNTIFS(Y$10:Y$25,TRUE)
    The count if rows that does not contain strikethroughs (cell I4) is populated using: =COUNTIFS(Y$10:Y$25,FALSE)
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Conditional Formatting: Strikethrough with Date
    By TSCworkhelp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-24-2017, 03:59 AM
  2. Conditional formatting - strikethrough row if value 'yes' entered
    By -jack in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-28-2016, 12:01 PM
  3. [SOLVED] Conditional Formatting - strikethrough cells in tab 2 that match table on tab 1
    By Didomenicon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2014, 09:59 PM
  4. Help! Conditional formatting on whole row to strikethrough row
    By nicki_jacko in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-20-2014, 05:30 PM
  5. Excel 2007 : strikethrough conditional formatting
    By HalaK in forum Excel General
    Replies: 10
    Last Post: 08-18-2011, 01:36 PM
  6. counting cells - strikethrough text
    By Martha in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-22-2008, 12:28 PM
  7. Counting text cells with strikethrough font!
    By Spellbound in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-19-2007, 11:23 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1