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. 

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

Mr Jamil Mohammad

I couldn't believe I receive your reply in such a speed!!

if I may bother you again - can you rewrite the macros just for A2 and B2 - no need for the whole rows - 

Thanking you for your FANTASTIC reply

Jamil's avatar
Jamil
Bronze Contributor
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. 

  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Mar 15, 2018

    Attached is the excel program I created for costing purposes.

    your blink macro looked ok but I can not imbed it into the program as I have very little knowledge of VBA. your kind assistance would be appreciated very much

     

    I don't know if this has sent the file "EUREKA Desking Program (per configuration).xlsm

    if not pls tell me how to send it to you - so that you will better understand what I want for the blink.

    Many many thanks

  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Mar 15, 2018

    Mr. Jamil Mohammad

    Good day

    can I trouble you again (maybe for the last time)

    could you re-write the macro for just G27 to blink whenever B27 is blank (no need to reverse)

    i.e. G27 will blink if B27 is blank - that's all

     

    How can I send you the File for you to understand better.

    I can not see "attach file" option

     

    Thank you for your patience and assistance

     

    • Jamil's avatar
      Jamil
      Bronze Contributor
      Mar 15, 2018
      Hi Lorenzo,

      If you click "Quick Reply" icon, then you dont have the option to attach workbook.
      If you click "Reply " then you can attach the sample workbook.

      • Lorenzo Kim's avatar
        Lorenzo Kim
        Bronze Contributor
        Mar 15, 2018

        Mr Jamil Mohammad

         

        Thank you for your reply.

        STILL, I do not know how to attach the excel file "EUREKA Desking Program (per configuration).xlsm"

        I can not see a provision for "attaching file" or a CLIP icon 

        I clicked the [Choose Files] - but I don't think it worked...

        anyway..

        In the excel file I mentioned, in the opening sheet "FORMULA" - it has already a VBA macro -- I do not know how to insert your Blink macro -- the module for Blinking - I know - just insert a module and paste it....the rest still a puzzle....

         

        or if it is not bothersome for you - can I have your email address so that I can send it directly to you....Thanks again

  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Mar 13, 2018

    Mr Jamil Mohammad

     

    Thank you very much for your assistance

Resources