Forum Discussion

Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Mar 06, 2018

Excel blinking cell

wouldn't it be nice - if in the CONDITIONAL FORMATTING (IN EXCEL) there is a provision to blink a cell content whenever required (based on cell condition) rather than to make a program for it??   HOW...
Excel
  • Jamil's avatar
    Jamil
    Mar 13, 2018

    Hello Lorenzo,

     

    Thanks for the feedback. as per your PM.  I have updated the macro. so that when G27 is empty, the B27 will start flashing. it will stop flashing when you put a value in G27. Please download the attached workbook which has the macro. 

Jamil's avatar
Jamil
Bronze Contributor

the blinking cell is possible but not without use of Macros.

shaker47455's avatar
shaker47455
Copper Contributor
Feb 07, 2019

hi,

 

hope you are doing great.

i tried below stated macros. but i am still stuck.

is there anyway i can put a conditional blinking for a column if the cell value says "no" then it should blink indefinitely and jsut for your info the column works on a formula. like if the validity has expired it will say "NO" in that particular cell.

    • RenasRS's avatar
      RenasRS
      Copper Contributor
      Jan 13, 2021

      Jamil This has been helpful, but I would like to expand on that. In the attached excel file you will see that 'B5' text is flashing'.

       

      1) How do I get the background flashing as well?

      2) How do I get it to stop flashing by inputting 'YES' into cell 'A5'?

       

      Thank you!

      • Jamil's avatar
        Jamil
        Bronze Contributor
        Jan 17, 2021

        RenasRS 

         

        I did not see any code in the file you shared. can you share the file with the code, so that I can modify it as per your need.

Share

Resources