+ Reply to Thread
Results 1 to 3 of 3

dynamic cell updates based on highlight colour of previous cell

  1. #1
    Registered User
    Join Date
    11-05-2019
    Location
    Derby, England
    MS-Off Ver
    Office 365
    Posts
    10

    dynamic cell updates based on highlight colour of previous cell

    Hi, Hoping someone can help with this (I am not very good in VBA or Excel advanced things sadly). I am trying to automate a horribly manual process before handing over the process on 30th June. In the attached file I want to amend the highlight colour in Cell A - this would then update the value in Cell B which in turn would update Cell C. I cannot get the value to change when I update the highlighting Cell A. I have added some Names to Cols A to C, but don't know if I need them.

    This bit of VBA is also there to be used in Col B.


    Function ColourIndex(CellColor As Range)

    Application.Volatile True

    ColourIndex = CellColor.Interior.ColorIndex

    End Function

    It is driving me mad, so if anyone has any ideas please let me know ASAp.

    Thanks,

    Andy
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: dynamic cell updates based on highlight colour of previous cell

    I recently came across this site that was helpful in diagnosing colors. I hope this resource helpshttps://www.extendoffice.com/documen...r-of-cell.html

  3. #3
    Valued Forum Contributor
    Join Date
    11-04-2018
    Location
    Denpasar
    MS-Off Ver
    Excel 2010
    Posts
    777

    Re: dynamic cell updates based on highlight colour of previous cell

    Maybe you need to add one more sub which is Worksheet_SelectionChange Sub.

    First remove the { } in the formula of cell B2.
    For example :
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Copy that formula until whatever row number you want in column B.

    Then in worksheet Sheet1 Module, have this code :
    Please Login or Register  to view this content.
    But still the index number won't change right after the cell is formatted to FILL color,
    but it will change when the user select any other cell.
    Last edited by karmapala; 06-27-2020 at 05:47 AM.

+ 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. [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. Replies: 6
    Last Post: 10-08-2018, 07:29 AM
  3. Auto highlight row & column of active cell without deleting existing cell colour
    By claire_wilson in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-22-2017, 08:31 PM
  4. [SOLVED] Change background colour to yellow if cell doesn't match the previous cell
    By drzeto in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2017, 05:33 PM
  5. [SOLVED] CF cell highlight based on another columns colour
    By toneNFFC in forum Excel General
    Replies: 3
    Last Post: 07-08-2015, 06:24 AM
  6. Highlight or colour a cell or cells based on cells in another range.
    By baffld in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-30-2012, 08:41 PM
  7. Cell highlight colour
    By Xx7 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2011, 03:21 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1