+ Reply to Thread
Results 1 to 4 of 4

Find a cell in a column with a specific color based on a predifined hierarchy

  1. #1
    Forum Contributor
    Join Date
    04-28-2016
    Location
    Stavanger, Norway
    MS-Off Ver
    365
    Posts
    142

    Find a cell in a column with a specific color based on a predifined hierarchy

    Hi,

    I need some help finding a cell in a column with a specific color based on a predefined hierarchy (please see attached excel sheet)

    The colors are ranked form 1-3, where 1 is green, 2 is yellow and 3 is red. I would like a formula/VBA script to be able to look through column C, D and E independently and find the color (which has been coloured with conditional formating) with the highest number to then color the cell with the ID (X1, X2, X3).
    I am thinking the formula would have to look for the colors based on a some sort of hierarchy, like is the cell Red > Yellow > green

    Assumption: The coloring of the cells in column C, D and E is derived in another tab and thus applied though conditional formating

    Please advice
    Attached Files Attached Files
    Last edited by mss90; 09-25-2020 at 09:31 AM.

  2. #2
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Find a cell in a column with a specific color based on a predifined hierarchy

    Quote Originally Posted by mss90 View Post
    Assumption: The coloring of the cells in column C, D and E is derived in another tab and thus applied though conditional formating
    In this case the right way to calculate it based on source data. Create example with data and CF.

  3. #3
    Forum Contributor
    Join Date
    04-28-2016
    Location
    Stavanger, Norway
    MS-Off Ver
    365
    Posts
    142

    Re: Find a cell in a column with a specific color based on a predifined hierarchy

    Quote Originally Posted by BMV View Post
    In this case the right way to calculate it based on source data. Create example with data and CF.
    That will be way to complicated in this case. Is it not possible to just write a function of VBA that simply color a cell red if it finds another cell that is red in a column?

  4. #4
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: Find a cell in a column with a specific color based on a predifined hierarchy

    In the case of source cell colored by conditional format -udf can't work.

+ 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] Find duplicate return specific column color
    By MaKo82 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-19-2019, 11:48 AM
  2. Sorting a sheet based on cell color in specific column
    By axtryo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2017, 10:42 PM
  3. How do I convert column hierarchy to flat file hierarchy
    By tbucki1 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 09-21-2016, 09:33 PM
  4. [SOLVED] Find specific phrase in a column and change the row color and its border
    By kundterra in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-27-2014, 05:13 PM
  5. [SOLVED] Find all cells with a specific background color then copy/paste to correct column
    By d_rose in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-20-2012, 10:18 AM
  6. Replies: 0
    Last Post: 09-01-2011, 10:19 AM
  7. how to - Insert predifined text in each cell of a column
    By npereira in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-18-2005, 04:52 PM

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