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
Bookmarks