Forum Discussion

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

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. 

shaker47455's avatar
shaker47455
Copper Contributor
Feb 07, 2019
Jamil wrote:

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


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.

Jamil's avatar
Jamil
Bronze Contributor
Feb 13, 2019

Hi Shaker,

 

please see attached.

 

if you put in any cell in column A  word no or result of formula. it will start flashing.

  • andy7883's avatar
    andy7883
    Copper Contributor
    Aug 06, 2020

    Hi Jamil, I

    I would like specific cells in my excel document to flash. 

    how can I achieve this. For eg; I have noted down an important bug details which I need to flash whenever I open that sheet. 

    Any help will be appreciated. 

Resources