Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unable to open Format - Cells | Excel Discussion (Misc queries) | |||
conditional format formulas | Excel Worksheet Functions | |||
Unable to pre-format cells to text when exporting data to csv or x | Excel Discussion (Misc queries) | |||
Using MIN in Conditional Format for cells with Formulas | Excel Discussion (Misc queries) | |||
Suddenly unable to re-format cells | Excel Discussion (Misc queries) |