UNABLE to conditional format CSE formulas cells
 

Could anyone please give me some advice on the problems when applying
conditional format on 'ctrl+shift+enter' CSE formulas cells using excel 2007?

The raw data is simply in 3 columns,
A B C
x-axis y-axis data
.... ... ...

My task is to plot the map of data according to its x-y axis values, and my
method is to use
{=IFERROR(INDEX('x.xls'!data,MATCH(1,('x.xls'!Col= x)*('x.xls'!Row=y),0)),"")}
all over the map. They all work very well.

The next step is to change the background color on the map based on the
value. However, the conditional formatting does not works on CSE formulas,
which has no response at all. I tried replace the formulas by the value of
data, it works perfectly. So, the problem is conditional formatting does not
recognize the value of CSE formulas. Is that right?

Could you please give me any idea how I could resolve this issue? PS: I do
not want use VBA macros. Thank you very much.

UNABLE to conditional format CSE formulas cells
 

Sorry I have just work out the way of doing that.

Another question is for a row of repeatted test / numbers, how could I
summarize them into a catelogue, e.g. transfer from A column to B column

A B
Sue Fred
Fred Richard
Richard Sue
Sue
Richard
....

No macros either. Thanks a lot.