Conditional formatting excel 2003

K

Kostas

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
 
J

joel

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.
 
K

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 - A Conditional Formatting ?'s 1
Excel Highlighting duplicates 0
conditional formatting in Excel 2007 1
Negative Conditional Formatting Excel 2003 2
Why won't my conditional formatting display in the cell 3
Conditional format lowest value greater than zero and copy formula 2
can conditional formatting varry the area it highlights based on c 3
Changing cell colors 1

Top