Flashing/Blinking background color of cell when a specific text is entered

  • Hi to all,


    I'm a beginner with VBA coding and I'm trying to figure out what to write as VBA macro in Excel.


    I want the background of a cell containing specific text "TBD" to flash from Red to White. For example, when someone enters "TBD" in the cell C10 and C28. I want the cells in the range C3:C31 to blink when the TBD is entered. See the attached file,


    Thanks for your help!

  • Administrative Note:


    Welcome to the forum. :)


    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.


    Read this to understand why we (and other sites like us) consider this to be important.


    (Note: this requirement is not optional. No help to be offered until the link is provided.)

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

  • Foul language will not be tolerated.


    The forum rules require you to provide a cross-post link - that is all you are being asked to do. Once this is done,we'll be happy to help you.

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules