+ Reply to Thread
Results 1 to 2 of 2

If (format) then (action)

  1. #1
    Registered User
    Join Date
    01-09-2019
    Location
    Galway, Ireland
    MS-Off Ver
    MS Office 365 online
    Posts
    1

    Lightbulb If (format) then (action)

    Is this possible?

    I want Excel to group text that has been formatted w/ "Strikethrough" into one bunch at the bottom of the file.

    Basically this is initially for a task management list tool and I want to be able to keep 'done' or 'cancelled' etc. items but move them automatically to the bottom of the list - or to another list, but that seems even more complicated. I'm a little new with this stuff and have only basics at the moment.

    How would this be done, or can it be done?

    Thanks in advance for help.
    That's me.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: If (format) then (action)

    A formula can't be used to detect a format, so you would need to latch onto some other data which is equivalent to the strikethrough formatting.

    Hope this helps.

    Pete

+ 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. Replies: 3
    Last Post: 02-28-2016, 10:51 AM
  2. My Action Tracker Keeps placing my competed action rows on sheet2 in the same place.
    By billybong33 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2014, 04:01 PM
  3. cell format/action
    By D Casten in forum Excel General
    Replies: 4
    Last Post: 10-25-2010, 10:49 AM
  4. Pop-up msg box action
    By nearlybled2death in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-22-2009, 07:20 AM
  5. Action not changing to General Format
    By dugong in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-12-2008, 12:36 PM
  6. [SOLVED] If column A completely empty, one action; if not, another action?
    By StargateFanFromWork in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-15-2006, 04:15 PM
  7. Replies: 4
    Last Post: 09-06-2005, 06:05 AM

Tags for this Thread

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