I want to copy the color (patern) and the value of a cell that has a
conditional format with out the conditional format formula.

Thanks

Kostas

The only way that can be done is with a macro and the macro isn't very
simple. The only way of determing the color is by examing the formula and
determinine if the results of any of the 3 conditional formulas are true.
conditional formating just doesn't have its own color index that you can
check and copy the color.

"Kostas" wrote:

I want to copy the color (patern) and the value of a cell that has a
conditional format with out the conditional format formula.

Thanks

Kostas

Thanks Joel

I was asking for an easy way to pass it to others.
I made a formula but as you now conditions of usage are changing

Anyway Thanks again

"joel" wrote:

The only way that can be done is with a macro and the macro isn't very
simple. The only way of determing the color is by examing the formula and
determinine if the results of any of the 3 conditional formulas are true.
conditional formating just doesn't have its own color index that you can
check and copy the color.

"Kostas" wrote:

I want to copy the color (patern) and the value of a cell that has a
conditional format with out the conditional format formula.

Thanks

Kostas