+ Reply to Thread
Results 1 to 3 of 3

Clear Cell content by color

  1. #1
    Registered User
    Join Date
    08-16-2020
    Location
    Thailand
    MS-Off Ver
    Google Sheet
    Posts
    22

    Clear Cell content by color

    Hello eveyone I hope to find help here,

    I m new and totally ingnorant about VBA Script language, and I had A request from My Boss to create A Google Sheet file where:

    just push a button

    1 The cell coloured in green will be cleared from the content
    2 Cell in Red will be cleared from the content and the background color turn back to Green and the cell Diveded

    this Script need to work n all the workbook

    thank you so much to who will help me

    Moderator Edit: I have move this post for you.
    Attached Files Attached Files
    Last edited by alansidman; 08-16-2020 at 08:14 AM.

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Clear Cell content by color

    I think you may have posted this question in the wrong place here on the forum. According to this:

    https://medium.com/macadamscripts/en...n-4316b70011bc

    and this:

    https://www.google.com/search?q=google+sheets+buttons

    coding in google sheets is a little more complicated than VBA. I don't use google sheets. I'm just posting this response to give you something to start with. I believe you'll probably get a better answer in this other area of the forum:

    https://www.excelforum.com/for-other...mobile-os-etc/

  3. #3
    Registered User
    Join Date
    08-16-2020
    Location
    Thailand
    MS-Off Ver
    Google Sheet
    Posts
    22

    Re: Clear Cell content by color

    thank you so much for your prompt answer , I take a look at the link that you suggest me and are very helpfull,

    as you suggest me I will Move the Thread in the Other Area


    thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Clear Content When a cell value = 0
    By Captain Hook in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2017, 01:06 PM
  2. [SOLVED] How to clear content on the cell that has background color from conditional formatting?
    By putritersenyum in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-18-2016, 10:13 AM
  3. [SOLVED] Clear content referencing another cell's same content
    By papusale in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-08-2015, 05:21 AM
  4. Swapping cell content to INCLUDE CELL FORMATTING (Text color, background color, etc)
    By jcpeterson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-10-2014, 10:09 AM
  5. How to clear cell's content?
    By NZL in forum Excel General
    Replies: 3
    Last Post: 03-09-2013, 10:04 AM
  6. To clear content if conditional formatting cell return gray color
    By W.Patrick in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-18-2013, 01:00 PM
  7. Clear content of cell if has some character.
    By Krzys in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-23-2007, 09:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1