Select colored cells?

[Pofski]

Hi,


I was wondering if the following is possible.

You have a list with conditional formatting with cells that changes the colors depending on any given parameter.

Is it possible to have another list with different columns that get filled in with the data from the first list depending on the color.

In other words, if in the first column you have red, orange and green, the green ones are automatically put in the green column, red in red and orange in orange.


Thank you in advance

 

[Hui]

You can't access the cells colors directly


You have two options


1. use the same logic as the CF in the second cells to set the values


2. Use a UDF to read the color and react accordingly

Such a UDF is shown as:

[pre]

Function GetColorIndex(Cell As Range)
GetColorIndex = Cell.Interior.ColorIndex
End Function

[/pre]

Then you can use =GetCellColor(A10)

It will show the color of a10

 

[Pofski]

Thanks Hui