"Kelly Lim" wrote:

In Excel
-----------
With a sample of colors pasted
(via copy paste special formats ok)
into say E2:E5

The above simply describes how to copy just the cell formats from a range of
cells to another. Cell formats will include fill colors (that's what I
thought our focus was here wrt your original post), font colors, etc. Note
that this would also implicitly copy over any conditional formatting present
in the source range. I'm mentioning this in view of Biff's clarification
that your current post could / may probably be a continuation of your
previous. Actually, I don't know. My responses were based solely on the face
value of what you described in your post where there was no hint / mention
that the fill colors were due to conditional formatting.

... which i don get any results at the end of the steps....

Were you able to download the sample file via the link I provided in the
other branch of this thread, and get it up working ?
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----