TM1 Forum

Hi Guys,

Here again. Just asking if there's another way where I can change the color of the cells based on values of the other cells. I know it can be done using Conditional Formatting. I'm using TM1 9.4 and Excel 2003. Also, as far as I know, if I put formulas wherever in the Format Area in active form, that won't work, right? But Conditional Formatting works in that area, but only 'Cell Value Is', where you can only format a cell with numeric values. What I want to do, is to format a cell based on the value of another cell. Obviously, 'Formula Is' won't work in the Format Area, it's non-sense I think. So I used 'Formula Is' in the first row data of the active form (in TM1RptRow). It does work after I click OK button in the Conditional Formatting window, initially. But after I Alt+F9, no formatting takes effect. It's simply because the formatting applied is based on the Format Area. But that Format Area can't be applied with 'Formula Is' conditioning. Am I right with this guys? Am I just missing something in this?, or if I'm not, do you know some other work around?

Thanks a lot!

Bunch

bunchukokoy wrote:What I want to do, is to format a cell based on the value of another cell. Obviously, 'Formula Is' won't work in the Format Area, it's non-sense I think.

Why do you assume this won't work? It may be nonsense for the format area but anything in the format area is "nonsense" because it's only there to be used as a format guide for the rest of the report. I have used this type of conditional formatting many times. As long as you structure the definition of the "condition" then it should copy down fine in the report area. You'll just have to be careful with the cell references in the "Formuaa is", you might need some "$" anchors and such but this approach WILL work. It's just not as simple as a "Value Is" type of conditional formatting.

Hi Tomok,

Thanks. You're right. It's OK now. I didn't change the "$" anchors, so the reference for the data rows stayed in that cell in the format area.

Thanks a lot.