Results 1 to 3 of 3

VBA for changing cell colour (individual and merged)

Threaded View

  1. 08-30-2020, 11:29 PM #1
    Phenomi
    Phenomi is offline
    Registered User
    Join Date
    04-15-2019
    Location
    Singapore
    MS-Off Ver
    2016 EXCEL
    Posts
    14

    Smile VBA for changing cell colour (individual and merged)

    Hi I would like to change a cell color from no fill to green just be double clicking. I am able to do it with single cell but not in merged cells. What other formula must i add into my existing ones to apply to merged cells as well? Thanks!

    Note: the double clicking should be able to reverse the colour change back to no fill.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Changing text colour in a cell based on value or colour of another cell.
    By Jeankartel in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-15-2019, 07:16 PM
  2. [SOLVED] Changing a cell that has a colour formatted to another colour after a period of time
    By kevexcel2018 in forum Excel General
    Replies: 11
    Last Post: 01-16-2018, 09:03 AM
  3. Changing chart colour to reflect colour of cell
    By hillwalker11 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2016, 03:12 AM
  4. Colour of Individual alphabets inside a cell by conditional
    By thilag in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2015, 08:24 AM
  5. Changing the colour of a cell based on the colour of another cell
    By Pete2931 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-11-2012, 03:35 AM
  6. Changing a cell's colour basing on other cells' colour
    By rhua5436 in forum Excel General
    Replies: 11
    Last Post: 09-23-2010, 05:49 AM
  7. Changing Cell Colour
    By Jeremy Rayne in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 01-29-2007, 08:29 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1