View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Conditional formatting excel 2003

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