Excel blinking cell

redha2205
Copper Contributor
Mar 01, 2021
Dear brother Jamil
I am trying to do the blinking cell for three conditions, If "On Duty" then "GREEN", If "On Leave" then "RED", If "On Waiting List" then "YELLOW" color. How to do it. I did my best and am getting error! Plz advise.. Many thanks sir
Peterw_2506
Copper Contributor
Dec 23, 2020
I agree about the blinking cell built into Conditional formatting. MS is so close to doing this, under the Fill button there is an effects button as well where you can have one or two colors. It would be nice if MS included in this area a Blink/Flashing button/command allowing users to choose colors, time of flashing, number of times something blinked.
These are my thoughts on this subject.
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
  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
    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.
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.
- Jamil
  Bronze Contributor
  Aug 28, 2020
  shaker47455 please see attached example.
  - 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!
Lorenzo Kim
Bronze Contributor
Mar 09, 2018
my personal opinion why in the conditional formatting in excel does not include the blinking mode is quite simple... (the programmers) THEY JUST SIMPLY MISSED IT!.... it totally slipped out of their minds!! IT ONLY SHOWS THAT THEY ARE HUMAN AFTER ALL........ why go through the tedious process of making a program for it when it can be readily built into the conditional formatting SIMPLY!?! admission does not mean guilty...:)

Forum Discussion

Resources