TM1 Active Form - Format a cell

Post Reply
raid412
Posts: 3
Joined: Wed Nov 20, 2019 4:23 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

TM1 Active Form - Format a cell

Post by raid412 »

I have a TM1 active form which displays my output..
My issue is, Based on a few cell values, I need to highlight cells which satisfies these conditions. Is it possible to change the font colour of a cell and not highlight the entire row.
supernaro
Posts: 4
Joined: Wed Feb 14, 2018 6:45 am
OLAP Product: Cognos TM1
Version: 10.3
Excel Version: 2016

Re: TM1 Active Form - Format a cell

Post by supernaro »

You can use excel conditional formatting in format area pane(these are the first few rows of the sheet) of Active forms.
raid412
Posts: 3
Joined: Wed Nov 20, 2019 4:23 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2016

Re: TM1 Active Form - Format a cell

Post by raid412 »

That worked, Thanks !
Post Reply