Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
razvan_brais
Creator III
Creator III

Change only cell font , color

Hy ,

Is there any way to change only a selected cell`s color and font? Because when I right click on the specific cell and choose custom format cell the modifies that I will do , it will be made to current expression or all expressions or all expressions and dimensions. But I want to make that change only to selected cell. 

1 Solution

Accepted Solutions
7 Replies
marcus_sommer

You could set the color within an attribute expression - click on the small + sign beside the dimensions/expressions and enter by color something like:

if(count(Dim1 /* are there more dimensions then & Dim2 and so on */) = 1, red(), black()).

- Marcus

razvan_brais
Creator III
Creator III
Author

I don`t want to collor an expression or a dimmension. I would like to color only the row that has Total for each column of a Pivot Table.

razvan_brais
Creator III
Creator III
Author

I`ve tried that option too. But It colors all the totals and sub-totals from my pivot table.

marcus_sommer

Then try to query the dimensionality like:

if(dimensionality() = 1, red(), black())

- Marcus

razvan_brais
Creator III
Creator III
Author

And where should I write this expression?

razvan_brais
Creator III
Creator III
Author

Thank you.